Search code examples
Writing a custom aggregate function...


postgresqlaggregate-functionsplpgsql

Read More
Call a set-returning function with an array argument multiple times...


sqlpostgresqljoinplpgsqlset-returning-functions

Read More
How to write script instead of function in pl/pgsql?...


scriptingplpgsql

Read More
Creating a trigger to update total count when any new employee is inserted...


sqlpostgresqlplpgsql

Read More
How can I use PL/pgSQL over a JDBC connection?...


postgresqljdbcplpgsql

Read More
Can read/write/delete OS files with plpgsql?...


postgresqlplpgsql

Read More
Using text in pl/pgsql brings empty set of results...


postgresqlplpgsqldynamic-queriespostgresql-10

Read More
Cannot set custom type object in plpgsql to null. Instead fields of that object becomes null...


sqlpostgresqlplpgsql

Read More
Transactions not working OK in a PostgreSQL 11 stored procedure...


postgresqlstored-proceduresplpgsql

Read More
Drop all functions in a namespace? (Execute generated DDL commands?)...


sqlpostgresqlplpgsqldynamic-sql

Read More
increment sequence in PostgreSQL stored procedure...


postgresqlsequenceplpgsql

Read More
DO block works fine, but function loops too many times?...


sqlpostgresqlfunctionloopsplpgsql

Read More
how to eliminate duplicates from my function in postgresql?...


sqlpostgresqlfunctionplpgsql

Read More
How can I send some http request from postgresql function or trigger...


postgresqlhttprequestplpgsql

Read More
Access dynamic column name of row type in trigger function...


sqlpostgresqltriggersplpgsqldynamic-sql

Read More
PostgreSQL function returning a data cube...


sqlpostgresqlplpgsqlolap

Read More
Saving file path in PostgreSQL, removes backslashes...


javaspringpostgresqlplpgsqlpgadmin-4

Read More
PostgreSQL PL/pgSQL syntax error with FOREACH loop...


postgresqlplpgsql

Read More
Add values from a column...


sqldatatablecountsumplpgsql

Read More
Select from different tables based on condition...


postgresqlplpgsql

Read More
PostgreSQL function returns type does not exist when called from C#...


postgresqlplpgsql

Read More
How to get entire table data or multiple rows returned from a function in PG/PLSQL with pgAdmin 4.2....


postgresqlplpgsqlset-returning-functions

Read More
PostgreSQL: Return a trigger error (raise exception) in JSON format...


postgresqlerror-handlingplpgsql

Read More
Accessing jsonb object in postgress throws error...


postgresqlplpgsqljsonb

Read More
PL/pgSQL Sum two jsons or two rows field by field...


sqlpostgresqlplpgsql

Read More
Find Min Or Max in custom aggregate function postgresql...


sqlpostgresqlaggregateplpgsql

Read More
Using COPY FROM STDIN in a stored function...


postgresqlstdinplpgsql

Read More
date is implicitly converting to integer...


postgresqldatetimeplpgsql

Read More
Postgres: how to declare user type variable?...


postgresqlplpgsql

Read More
Add field in RETURNS TABLE pgplsql function...


postgresqlplpgsql

Read More
BackNext