Search code examples
Spring test @Sql throws "Unterminated dollar quote started ... Expected terminating $$"...

postgresqlplpgsqlspring-testspring-boot-test

Read More
Loop with many DELETEs not finishing even though the statements complete OK...

sqlpostgresqlplpgsqlsql-deletedynamic-sql

Read More
How to enable plpython3u on macOS?...

postgresqlmacosplpgsql

Read More
Output result set in a PL/pgSQL script...

postgresqlplpgsqlresultset

Read More
Does postgres-nodejs support pl/pgsql block code?...

javascriptnode.jspostgresqlexpressplpgsql

Read More
How to list tables of specific database and sort them by size with PostgreSQL?...

databasepostgresqlplpgsql

Read More
Passing a date to a function gives conversion to integer error...

postgresqlfunctionplpgsql

Read More
Syntax error in PL/pgSQL function with dynamic SQL...

sqlpostgresqlwhere-clauseplpgsqldynamic-sql

Read More
Wrap PostgreSQL functions in another to conditionally combine results...

sqlpostgresqlfunctionjoinplpgsql

Read More
Avoid multiple calls on same function when expanding composite result...

sqlpostgresqlquery-optimizationplpgsql

Read More
How to return multiple rows from PL/pgSQL function?...

postgresqlplpgsql

Read More
How to improve performance of a function with cursors in PostgreSQL?...

postgresqlfunctionplpgsqldatabase-performancedatabase-cursor

Read More
Dynamically generated CURSOR in Postgresql...

postgresqldynamicplpgsqldatabase-cursor

Read More
Counting number of weekdays between two dates...

postgresqltime-seriesplpgsql

Read More
How to declare an array of rowtype in a PostgreSQL function?...

arraysfunctionpostgresqlaggregate-functionsplpgsql

Read More
Is there a way to create a dynamic number of columns in a plpgsql function return value?...

sqlpostgresqlplpgsql

Read More
Loop through columns of RECORD...

postgresqlloopsfor-looprecordplpgsql

Read More
array_length() of an empty array returning NULL...

arrayspostgresqlplpgsql

Read More
Error at "OLD <> NEW" when creating function in Liquibase...

postgresqlplpgsqlliquibase

Read More
How to update type of all columns with the same name in all tables in one query in Postgres?...

sqlpostgresqlplpgsqlinformation-schema

Read More
RETURN cannot have a parameter in function returning set while returning from function...

postgresqlfunctionpivotplpgsqlreturn-type

Read More
IP increment function in PL/pgSQL...

postgresqlplpgsql

Read More
Error when creating a gin index with table of millions of documents...

postgresqlerror-handlingplpgsql

Read More
PostgreSQL: Combine two JSON objects into a single JSON object...

sqlpostgresqlsubqueryplpgsqlpostgres15

Read More
PostgreSQL Exception Handling...

postgresqlplpgsql

Read More
How to initialize a rowtype array in pl/pgsql?...

postgresqlplpgsql

Read More
Return zero if no record is found...

sqlpostgresqlnullplpgsqlcoalesce

Read More
How to identify slow queries in PostgreSQL function?...

postgresqlfunctionperformancequery-optimizationplpgsql

Read More
postgres function that takes the result of a select query...

sqlpostgresqlplpgsql

Read More
ERROR: function pg_catalog.extract(unknown, integer) does not exist...

sqlpostgresqlplpgsqlpartitioning

Read More
BackNext