Search code examples
Postgresql - "ERROR: syntax error at or near "-" when trying to pass a number paramet...


sqlpostgresqlplpgsqldatabase-trigger

Read More
Postgresql: insert the same data a few times...


postgresqlplpgsql

Read More
PostgreSQL : Call a psql function with the return of a Select as a parameter...


postgresqlplpgsql

Read More
Dealing with error "record or row variable cannot be part of multiple-item INTO list"...


plpgsql

Read More
Postgresql: inserting some proper default values or NAs into table with maltyped values?...


postgresqlcsverror-handlingplpgsql

Read More
Using multi-column SETOF result from a PL/pgSQL function in via jdbc...


sqlpostgresqljdbcplpgsql

Read More
Select into an array of composite types in plpgsql...


postgresqlplpgsql

Read More
Automating partitions creation in Postgres 10...


postgresqldateplpgsqlpartitioningdynamic-sql

Read More
Postgres if statement inside function inserting values...


postgresqlif-statementsql-insertplpgsql

Read More
INSERT JSON into two tables and return serial ID...


sqldatabasepostgresqlinsertplpgsql

Read More
Missing FROM-clause entry for table »rowtype«...


postgresqlplpgsqlpartitioningdynamic-sqlpostgresql-9.4

Read More
How to do global exception handler in postgres?...


postgresqlplpgsqlpostgresql-9.3postgresql-9.4

Read More
Create non conflicting temporary tables in a Pl/pgSQL function...


postgresqlplpgsql

Read More
How to pass a record to a PL/pgSQL function?...


postgresqlfunctionparameterstriggersplpgsql

Read More
String in Postgres; validation of the contents of a string...


databasepostgresqlvalidationplpgsql

Read More
Create function with temporary tables that return a select query using these temp tables...


plpgsqlstored-functionsgreenplum

Read More
Trying to create dynamic query strings with PL/PgSQL to make DRY functions in PostgreSQL 9.6...


sqldatabasepostgresqlplpgsqldynamic-sql

Read More
Postgres Dynamic COPY Statement...


postgresqlplpgsqlpostgresql-9.6

Read More
syntax error when running postgresql function/stored procedure...


postgresqlplpgsql

Read More
How to put part of a SELECT statement into a Postgres function...


sqldatabasepostgresqlfunctionplpgsql

Read More
How do I debug trigger recursion in PostgreSQL?...


postgresqldebuggingrecursiontriggersplpgsql

Read More
Why can't my POSTGRESQL trigger function find my column when using the NEW parameter?...


sqlpostgresqlplpgsqldatabase-trigger

Read More
How to declare a record on a user-defined type in postgres...


postgresqlplpgsqlrecord

Read More
PL/Pgsql more than one row returned by a subquery...


sqlpostgresqlplpgsql

Read More
How to use PL/pgSQL to construct a table with dynamic columns...


sqlpostgresqlplpgsqldynamic-sqlcrosstab

Read More
Create function if records exist then do nothing else run some code in postgres...


postgresqlplpgsql

Read More
PostgreSQL using variable name as string literal...


postgresqltriggersplpgsql

Read More
PostgreSQL: test if user exists else create new user returning his id...


sqlpostgresqlplpgsqlpostgresql-9.1

Read More
Query with CASE and generate_series(), order resulting timestamptz descending...


sqlpostgresqlsql-order-byplpgsqlset-returning-functions

Read More
Function to update records from JSON in Postgres...


jsonpostgresqljpaplpgsql

Read More
BackNext