Does a COMMIT work within an anonymous plgpsql function in PostgreSQL 9.5?
2019-05-23
How to eliminate for loop in a nested aggregate problem
2019-05-22
Getting the contents of a json file as a variable in plpgsql?
2019-05-06
When is SELECT necessary in PL/pgSQL functions?
2019-04-30
Function with SQL query has no destination for result data
2019-04-27
Create index if it does not exist
2019-04-22
Using text in pl/pgsql brings empty set of results
2019-04-05
Unable to wrap a simple CTE in plpgsql loop
2019-03-31
How can I send some http request from postgresql function or trigger
2019-03-28
SQL Sub queries in check constraint
2019-03-23
How can I use an environment variable in a Postgres function?
2019-03-21
PostgreSQL function returns type does not exist when called from C#
2019-03-20
How to use COLUMN and TABLE options in a RAISE statement
2019-03-17
PostgresSQL dynamic execute with argument values in array
2019-03-09
How to concatenate arrays with user-defined types in pgsql?
2019-03-08
Surprising results from assigning multiple variables in FOR loop
2019-03-05
PL/pgSQL anonymous code block
2019-02-26
Migrating triggers, functions and procedures from Oracle to PostgreSQL
2019-02-13
Dynamic UPDATE fails due to unwanted parenthesis around string in plpgsql
2019-02-06
pgsql Materialized view refresh
2019-02-01