Search code examples
"ERROR: query has no destination for result data" for function with INSERT...

postgresqlplpgsql

Read More
PostgreSQL table variable...

sqlpostgresqlplpgsqltable-variable

Read More
Get default serial value after INSERT inside PL/pgSQL...

postgresqlplpgsqlsql-insertsql-returningnextval

Read More
How to execute a query multiple times in PostgreSQL...

sqlpostgresqlplpgsql

Read More
Dynamic SELECT INTO in PL/pgSQL function...

postgresqlvariable-assignmentplpgsqldynamic-sqlstored-functions

Read More
How to use SIMILAR TO with variables...

postgresqlpattern-matchingplpgsql

Read More
How do I create a nested function in PL/pgSQL?...

postgresqlscopeplpgsqlpostgresql-9.5

Read More
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
BackNext