Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

New posts in plpgsql

ERROR cursor does not exist after first loop in PL/pgSQL

sql postgresql plpgsql

Logging to a log table in a function shows the same time for all actions in it although they are minutes apart

postgresql plpgsql

Is it possible to create a function in PostgreSQL that takes a column name as input?

database function postgresql plpgsql

Passing array of a composite type to stored procedure

sql postgresql stored-procedures plpgsql

How can I print text to stdout from a psql query?

postgresql plpgsql

Query on subquery that gets tables' names

postgresql plpgsql dynamic-sql identifier postgresql-9.2

How To Restrict Delete using PL/pgSQL trigger?

postgresql triggers plpgsql postgresql-9.6

Can I use an SQL statement in assignment inside a PL/pgSQL function?

sql postgresql plpgsql

Multiple ALTER TABLE ADD COLUMN in one SQL function call

sql postgresql plpgsql

PL/pgSQL "Malformed array literal" error within for loop

arrays postgresql plpgsql

How to pass composite types to PL/pgsql function?

c# postgresql plpgsql npgsql

PostgreSQL: month := interval '30 days';

postgresql plpgsql

Returned data type information_schema.identifier does not match expected type

postgresql types plpgsql information-schema

How to call a function in regexp_replace with matches?

sql regex postgresql parsing plpgsql

Record returned from function has columns concatenated

sql postgresql join plpgsql set-returning-functions

How do I Iterate through individual fields of OLD records in Postgres plpgsql trigger?

postgresql triggers plpgsql

SQL state: 42601 syntax error at or near "11"

postgresql datetime plpgsql dynamic-sql

Declare COUNT value as variable (PostgreSQL)

postgresql variables count plpgsql

Set empty strings ('') to NULL in the whole database

sql postgresql plpgsql dynamic-sql information-schema
Older Entries »