Search code examples
postgresql: syntax error at or near "IF" why?...


postgresqlplpgsql

Read More
Weird now() time difference with Postgres triggers...


postgresqltransactionstimestampsequelize.jsplpgsql

Read More
How to parameterize parametric column type in PostgreSQL `execute format()`?...


postgresqlplpgsql

Read More
why is postgresql considering this subquery column-name not fully qualified and ambiguous...


sqlpostgresqlplpgsqlambiguity

Read More
How to simplify running a function if it exists, falling back on other code?...


postgresqlplpgsql

Read More
How to pass NEW.* to EXECUTE in trigger function...


postgresqltriggersplpgsqldynamic-sql

Read More
Postgres execute dynamic anonymous block in an anonymous block...


postgresqlplpgsql

Read More
COPY with dynamic file name...


sqlpostgresqlplpgsqldynamic-sqlpostgresql-copy

Read More
PL/pgSQL to copy data from tables dynamically...


postgresqlplpgsqlpostgresql-9.4string-interpolation

Read More
Select and return value with Plpgsql function...


sqlpostgresqlfunctionsyntaxplpgsql

Read More
How to call function with a custom type array as its parameter from the SQL editor...


postgresqlplpgsqlpostgresql-13

Read More
Count the rows affected by plpgsql function...


phppostgresqlpdocountplpgsql

Read More
Repartitioning existing table online...


postgresqltransactionsplpgsqlpartitioningdata-migration

Read More
PostgreSQL performance of ad-hoc SQL vs functions...


postgresqlprepared-statementplpgsqlsql-execution-plan

Read More
How to use triggers to prevent duplicate records in PostgreSQL?...


postgresqldatabase-designtriggersconstraintsplpgsql

Read More
Looking for a PL/PGSQL function to return N columns...


postgresqlplpgsqlpostgresql-9.3postgresql-9.4

Read More
PL/pgSQL: PERFORM vs CALL...


postgresqlfunctionplpgsqlprocedure

Read More
How to use variable settings in trigger functions?...


postgresqltriggersglobal-variablesplpgsql

Read More
Generating Fibonacci sequence with PL/pgSQL function...


sqlpostgresqlplpgsqlset-returning-functions

Read More
how to iterate and append jsonb in postgres db function...


postgresqlaggregate-functionsplpgsqljsonb

Read More
trigger does not work for a specific table postgres 11...


postgresqltriggersplpgsql

Read More
ERROR: syntax error at or near "DECLARE" LINE 1: BEGIN DECLARE custo double precision defa...


postgresqlplpgsql

Read More
Pass List<String> into postgres' function as parameter...


javapostgresqlspring-data-jpaspring-dataplpgsql

Read More
PostgreSQL RDS avoid hard coding the connection password when using dblink_connect()...


sqlpostgresqlamazon-rdsplpgsql

Read More
How to use a record type variable in plpgsql?...


postgresqlfunctionvariablesplpgsqltable-variable

Read More
Not able to pass default values to parameters in stored procedure Redshift...


amazon-web-servicesamazon-redshiftplpgsql

Read More
CRC32 function with PL/pgSQL...


postgresqlplpgsqlcrccrc32

Read More
Can I use EXCEPTIONs in a FOR LOOP to force continuation on error?...


postgresqlloopsexceptionplpgsql

Read More
PL/pgSQL select statement inside trigger returns null using where NEW...


sqlpostgresqltriggersplpgsql

Read More
can not pass date to function correctly...


postgresqlplpgsql

Read More
BackNext