Search code examples
Redshift stored procedure is created but when called, it says column <sp_name> doesn't exi...


amazon-web-servicesstored-proceduresamazon-redshiftplpgsql

Read More
How to log queries inside PLPGSQL with inlined parameter values...


postgresqlloggingprepared-statementplpgsqlsql-execution-plan

Read More
Execute multiple functions together without losing performance...


postgresqlplpgsqldatabase-performancequery-performancepostgresql-performance

Read More
Pass multiple sets or arrays of values to a function...


sqlpostgresqlstored-proceduresmultidimensional-arrayplpgsql

Read More
How to run plpgsql without creating a function?...


postgresqlplpgsql

Read More
How to fix postgres-utils eval() error: missing FROM-clause entry for table "foo"?...


sqlpostgresqlevalplpgsql

Read More
postgres: How to generically make a column immutable?...


postgresqldynamicplpgsqldatatrigger

Read More
Calling stored procedure from pgsql-http doesn't store values in my trigger...


postgresqlplpgsql

Read More
PLPGSQL Dynamic Query - ERROR:PL/pgSQL function inline_code_block lin...


postgresqlplpgsqldynamic-queries

Read More
Serialize/Unserialize with plpgsql...


phppostgresqlserializationdeserializationplpgsql

Read More
How to return temporary table from a PostgreSQL function?...


postgresqlstored-proceduresplpgsql

Read More
pseudo_encrypt() function in plpgsql that takes bigint...


sqlpostgresqlplpgsql

Read More
Why is the condition used for the trigger never satisfied on PostgreSQL?...


sqlpostgresqlexceptiontriggersplpgsql

Read More
Zero length delimited identifier error on postgresql function...


c#.netpostgresql.net-coreplpgsql

Read More
plpgSQL - ambiguous column name when using CTE...


stored-proceduresplpgsql

Read More
Get IDs from multiple columns in multiple tables as one set or array...


postgresqlfunctionplpgsqldynamic-sqlmultiple-tables

Read More
PostgreSQL IF statement...


sqlpostgresqlif-statementplpgsql

Read More
How to use EXECUTE FORMAT ... USING in Postgres function...


postgresqlformatplpgsqlusingexecute

Read More
PL/pgSQL function with VARCHAR as Parameter...


postgresqlplpgsql

Read More
Pass parameters to view (set returning function?)...


sqlpostgresqlstored-proceduresparameter-passingplpgsql

Read More
How to use array variable in my sql statement in plpgsql...


sqlpostgresqlplpgsql

Read More
Using temp table in PL/pgSQL procedure for cleaning tables...


postgresqlplpgsqlselect-into

Read More
Stored procedure to return count...


sqlpostgresqlstored-proceduresplpgsql

Read More
after insert trigger to find longest prefix to each line is very slow...


postgresqlperformancetriggersplpgsql

Read More
PL/pgSQL transaction behavior when function calls another...


plpgsql

Read More
find LCOM metric (all pairs of a class's methods that are not related)...


postgresqlplpgsql

Read More
CREATE FUNCTION statement in an IF block throws error, while running on its own works...


postgresqlplpgsqlddldollar-quoting

Read More
Dynamic SQL and SQL injection...


postgresqlplpgsqlsql-injectiondynamic-sql

Read More
PLPGSQL: Query JSONB Array size...


postgresqlplpgsql

Read More
Pgsql return from second table even if no record exist...


sqlpostgresqlplpgsql

Read More
BackNext