Search code examples
How can a PostgreSQL function accept an integer or array of integers for the same function?...


arrayspostgresqltypesplpgsqlpostgresql-9.6

Read More
SET LOCAL to a previously stored value...


postgresqlsettingsplpgsqllock-timeout

Read More
unaccent() does not work with Greek letters in plpgsql dynamic query...


postgresqlplpgsqldynamic-sqlaccent-insensitiveunaccent

Read More
Call table functions from function in PL/pgSQL - is that possible?...


postgresqlfunctionplpgsql

Read More
Postgres with CTE and return multiple tables...


postgresqlplpgsql

Read More
Select tables to alter...


sqlpostgresqlplpgsqldynamic-sqlpostgresql-9.6

Read More
Catch a warning using plpgsql...


postgresqlexceptionerror-handlingwarningsplpgsql

Read More
column reference "col_1" is ambiguous plpgsql...


postgresqlplpgsql

Read More
Postgres : Complex Multiple Update query for one to many relationship...


node.jspostgresqlplpgsqlpg

Read More
Check if a `RECORD` variable is initialized...


postgresqlplpgsql

Read More
How to pass a string parameter to plpgsql function?...


postgresqlparametersplpgsqldynamic-sqlstored-functions

Read More
Postgresql Error 42883 When Executing Custom Function...


databasepostgresqlplpgsql

Read More
How to concat two string in postgresql function?...


postgresqlplpgsqlconcatenation

Read More
How to zip CSV files through stored function in postgres...


postgresqlplpgsqlzipstored-functions

Read More
How do I check is a postgresql procedure exists before calling it...


postgresqlplpgsql

Read More
passing function parameters to dynamic query string...


postgresqlplpgsqldynamicquery

Read More
How to use Active Model Serializer without an Active Record Model?...


ruby-on-railsplpgsqlpgactive-model-serializers

Read More
Use returned values from a query in the same procedure...


sqlpostgresqlplpgsql

Read More
Using replace() inside a loop...


sqlpostgresqlplpgsqldynamic-sqlddl

Read More
How to get nth line from text column in postgres...


sqlregexpostgresqlplpgsqlstored-functions

Read More
Redshift UNLOAD to S3 using PL/SQL loop variable...


amazon-web-servicesamazon-redshiftplpgsql

Read More
postgresSQL How to apply trigger only on updated row?...


postgresqlplpgsqldatabase-trigger

Read More
Equivalent of Informix GLOBAL modifier in PostgreSQL...


sqlpostgresqlplpgsqlinformix

Read More
Stored procedure: how to check if NULL is present in postgresql array or not?...


postgresqlplpgsql

Read More
Is static sql to be preferred over dynamic sql in postgresql stored procedures?...


performancestored-proceduresplpgsql

Read More
Sum variables when condition is met in sql...


sqlpostgresqlplpgsql

Read More
How to fetch results from a plpgsql function...


postgresqlplpgsql

Read More
How to get the first id from the INSERT query...


sqlpostgresqlplpgsql

Read More
Create the query as a string and execute that in PostgreSQL 10...


postgresqlplpgsqldynamic-sql

Read More
postgres function that returns random enum...


postgresqlplpgsql

Read More
BackNext