Search code examples
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
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
Split string with two delimiters and convert type...

postgresqlplpgsqlset-returning-functions

Read More
Syntax error near 'WHEN place.price > 3000 THEN' in PostgreSQL function...

sqlplpgsqlsupabase

Read More
Postgresql: resolve a one-to-many relationship and delete given tuples, all in one query...

postgresqlsequelize.jsplpgsql

Read More
How to disambiguate a plpgsql variable name in a ON CONFLICT clause?...

sqlpostgresqlplpgsqlupsertname-conflict

Read More
PostgreSQL stored procedure to get an employee by input ID from a joined table...

sqlpostgresqlstored-proceduresplpgsqlpgadmin-4

Read More
Create a function in PostgreSQL...

sqldatabasepostgresqlfunctionplpgsql

Read More
Create procedure to execute query in PostgreSQL...

mysqldatabasepostgresqlstored-proceduresplpgsql

Read More
FOR EACH STATEMENT trigger example in PostgreSQL...

databasepostgresqltriggersplpgsqlpostgresql-triggers

Read More
Iterating over integer[] in PL/pgSQL...

arrayspostgresqlloopsplpgsqlpostgresql-8.4

Read More
Loop over array dimension in plpgsql...

databasepostgresqlfor-loopmultidimensional-arrayplpgsql

Read More
BackNext