Search code examples
Returning dynamic query results from PL/PGSQL function, multiple rows...

postgresqlplpgsqldynamicquery

Read More
Parallel safety and exception handling in Postgres...

postgresqlplpgsql

Read More
Count previous rows within range...

sqlpostgresqlplpgsqlcommon-table-expressionwindow-functions

Read More
How to create operator if not exists...

sqlpostgresqloperator-overloadingplpgsql

Read More
I want to have my pl/pgsql script output to the screen...

postgresqlfor-loopplpgsql

Read More
How do I pass in a table parameter to this function?...

postgresqlcastingplpgsql

Read More
Error while trying to insert data into timestamp field using plpgsql...

postgresqltimestampplpgsql

Read More
PSQL Command Line Arguments in DO script...

postgresqlcommand-lineparameter-passingplpgsqlpsql

Read More
Send variables to a function, casting?...

sqlpostgresqlplpgsqlpostgresql-8.4

Read More
Returning boolean from SQL function...

sqlpostgresqlstored-proceduresplpgsql

Read More
why functions that returns tables are so much slower then running the actual query?...

postgresqlplpgsql

Read More
Postgres cursor is not taking multiple parameters...

postgresqlplpgsqldatabase-cursor

Read More
Why does this multiple "DO" block script work in DBeaver but fail in pgAdmin?...

postgresqltransactionsplpgsqlpgadmin

Read More
How to return a table by rowtype in PL/pgSQL...

postgresqlpolymorphismplpgsqldynamic-sql

Read More
Store query result in a PL/pgSQL variable...

sqlpostgresqlfunctionplpgsql

Read More
PostgreSQL drop constraint with unknown name...

postgresqlplpgsqldynamic-sqlpsql

Read More
Execute deferred trigger only once per row in PostgreSQL...

postgresqldatabase-designtriggersplpgsql

Read More
Dynamically Access Columns and Cast Data Types in PostgreSQL Functions...

postgresqltriggersuser-defined-functionsplpgsql

Read More
Dynamic INSERT statement based on hstore keys...

sqlpostgresqlplpgsqlhstore

Read More
Handle result when dynamic SQL is in a loop...

postgresqlcountplpgsqldynamic-sql

Read More
How to fetch from cursor over single column of composite type into a variable of that type in PL/pgS...

postgresqlplpgsqldatabase-cursor

Read More
Converting function from Oracle to PostgreSQL...

oracle-databasepostgresqldatabase-migrationplpgsql

Read More
Triggers are not executed when a field is changed via NEW...

sqlpostgresqltriggersplpgsql

Read More
Passing array to WHERE IN on multiple columns in a function...

sqlarrayspostgresqlplpgsqlsql-function

Read More
Postgresql- trigger to insert and then to truncate table...

postgresqltriggersplpgsql

Read More
Loop on tables with PL/pgSQL in Postgres 9.0+...

postgresqlvariablesloopsplpgsqltablename

Read More
postgresql round half down function...

postgresqlfloating-pointplpgsqlroundingfloating-accuracy

Read More
syntax error when creating an if statement on postgresql function...

plpgsqlpostgresql-14

Read More
Special variable FOUND not set properly?...

postgresqlplpgsql

Read More
How to convert integer[] to jsonb in a PL/pgSQL code block...

sqlpostgresqlplpgsqljsonb

Read More
BackNext