Search code examples
syntax error at or near "="...


databasepostgresqlplpgsql

Read More
Declare not working in funtion using postgresql...


postgresqlplpgsql

Read More
Converting a returned SETOF into An Array in PL/PgSQL (specifically)...


postgresqlplpgsqlarray-agg

Read More
Apply function to temp table inside another function...


postgresqlplpgsqldynamic-sql

Read More
Postgresql Functions - Using VARIADIC arguments of text type...


postgresqlplpgsqlamazon-rdsdynamic-sqlvariadic-functions

Read More
Understanding PostgreSQL & plpgsql defense against code injection...


sqlpostgresqlsql-injectionplpgsql

Read More
Sanitize user input with the USING keyword in PL/pgSQL...


sqldatabasepostgresqlplpgsqldynamic-sql

Read More
ERROR: cursor "<unnamed portal>" does not exist...


postgresqlplpgsql

Read More
Using Single quotes for a value inside plpgsql function...


postgresqlplpgsqlpostgresql-9.3

Read More
PostgreSQL plpgsql - variable column names...


postgresqlplpgsql

Read More
Trigger with dynamic field name...


postgresqltriggersplpgsqldynamic-sqlpostgresql-9.3

Read More
Returning multiple values from UPDATE query in PostgreSQL...


sqlpostgresqlsql-updateplpgsqlsql-returning

Read More
Convert timestamp gives result in the future...


postgresqlplpgsql

Read More
ON CONFLICT ON CONSTRAINT trigger from any constraint...


postgresqlplpgsqlupsert

Read More
PostgreSQL - Any downside to using JSONB as a single function argument...


postgresqlfunctionplpgsql

Read More
Issue While creating function in PostgreSQL "ERROR: syntax error at or near "ROWTYPE"...


sqlpostgresqlplpgsql

Read More
Sending string as text to function POSTGRESQL...


postgresqlplpgsql

Read More
How to set timezone inside a postgres function...


postgresqlfunctionstored-proceduresplpgsql

Read More
How to fetch two different columns from two different tables and put it into a third table with one ...


sqlpostgresqlplpgsqlpostgresql-9.5

Read More
Downsampling a postgresql table...


sqlpostgresqlplpgsqldownsampling

Read More
How to update column value based on other column change within same table without any primary key co...


postgresqltriggersplpgsqlpostgresql-9.3

Read More
Execute INTO to accept NULL values...


postgresqlinsertplpgsqlexecute

Read More
PostgreSQL: replace plpgsql function by sql function...


postgresqlplpgsqlsql-function

Read More
PLPGSQL cursor loop dynamic sql...


oracle-databasepostgresqlplsqlplpgsql

Read More
Parameter defaults for ALTER FUNCTION?...


postgresqlfunctionplpgsql

Read More
PostgreSQL: get input parameters as row values...


postgresqlsyntaxplpgsql

Read More
Postgresql plpgsql function syntax error...


postgresqlplpgsql

Read More
Porting Oracle procedure to PostgreSQL (exception codes from orafce for utl_file module)...


postgresqlplpgsqlorafce

Read More
Populate a Postgres table with old values from a function (not a trigger)...


sqlpostgresqlfunctionconcurrencyplpgsql

Read More
Postgres plpgsql with PERFORM data-modifying CTE queries...


postgresqlplpgsqlcommon-table-expression

Read More
BackNext