Search code examples
Declaring a cursor in plpgsql fails...


postgresqlplpgsqlsupabase-database

Read More
ERROR: syntax error at or near "QUERY" QUERY EXECUTE 'set enable_parallel_append = off...


postgresqlplpgsql

Read More
Unnest multiple arrays in parallel...


arrayspostgresqlarraylistplpgsqlset-returning-functions

Read More
Delete data from child tables with Stored Procedure...


databasepostgresqlstored-proceduresplpgsql

Read More
Variables for identifiers inside IF EXISTS in a plpgsql function...


postgresqlpostgresql-9.1plpgsqldynamic-sqlexists

Read More
Count rows affected by DELETE...


sqlpostgresqlplpgsqlpostgresql-9.1postgresql-9.2

Read More
Using variables in a PL/pgSQL function...


postgresqlparameter-passingnaming-conventionsplpgsqlquotes

Read More
How to query a table whose name is built from a PL/pgSQL function result?...


sqlpostgresqlplpgsqlpartitioning

Read More
column does not exist when function return query execute plpgsql...


postgresqlplpgsql

Read More
Why is the explicit table name necessary in this Postgres Function?...


postgresqlplpgsqlsql-function

Read More
Postgresql: From array of jsons to a single, id-indexed json...


sqljsonpostgresqlplpgsqljsonb

Read More
How to pass OLD, NEW and identifiers to EXECUTE in a trigger function?...


databasepostgresqltriggersplpgsqldynamic-sql

Read More
Trigger raising: "ERROR: stack depth limit exceeded"...


sqlpostgresqlplpgsqldatabase-trigger

Read More
Validate array of table names...


sqlarrayspostgresqlplpgsql

Read More
How to solve ERROR: operator is not unique: "unknown" - "unknown" in a dynamic S...


sqlstored-proceduresamazon-redshiftplpgsqldynamic-sql

Read More
How to change column names returned from a function?...


sqlpostgresqlplpgsql

Read More
Count previous rows within range...


sqlpostgresqlplpgsqlcommon-table-expressionwindow-functions

Read More
Function takes significantly longer than specified timeout...


postgresqlgoogle-cloud-platformstored-proceduresplpgsqlgoogle-cloud-sql

Read More
BREAK statement in PL/pgSQL...


databasepostgresqlloopsplpgsqlbreak

Read More
Refactor a PL/pgSQL function to return the output of various SELECT queries...


sqldatabasepostgresqlplpgsqldynamic-sql

Read More
Return multiple IDs from a function and use the result in a query...


sqlpostgresqlplpgsqlpostgresql-9.1

Read More
Attempting to write PostgreSQL 9.0 function...


functionpostgresqlplpgsql

Read More
Can I make a plpgsql function return an integer without using a variable?...


postgresqlfunctionvariablesparametersplpgsql

Read More
Could not access file "$libdir/plpgsql": No such file or directory...


postgresqlosx-lionplpgsqlpostgresql-9.3postgres.app

Read More
Create Function: Syntax Error at or near $$...


sqlpostgresqlfunctionplpgsqldynamic-sql

Read More
PostgreSQL CASE usage in functions...


postgresqlconditional-statementscaseplpgsql

Read More
PL/pgSQL function - Catch errors...


postgresqlexceptionplpgsqlpsql

Read More
Locking rows behaviour for a temporary table in a PLPGSQL function...


sqlpostgresqlconcurrencytriggersplpgsql

Read More
How to show what privileges a user has on a database in Postgres database?...


postgresqlplpgsql

Read More
How to RAISE NOTICE in PostgreSQL?...


postgresqlplpgsql

Read More
BackNext