Search code examples
structure of query does not match function result type...

sqldatabasepostgresqlplpgsqlresulttype

Read More
plpgsql error "RETURN NEXT cannot have a parameter in function with OUT parameters" in tab...

databasepostgresqlexceptionplpgsqlreturn-next

Read More
How to use RETURN NEXT in a PL/pgSQL function?...

sqldatabasepostgresqlplpgsqlreturn-next

Read More
How to return `SETOF RECORD` type from a function in PostgreSQL?...

sqldatabasepostgresqlplpgsqlreturn-query

Read More
Using `RETURN NEXT` and `RETURN QUERY` in the same Postgres function...

databasepostgresqlfunctionplpgsqlreturn-next

Read More
What is a "non-SETOF function" in PostgreSQL?...

sqldatabasepostgresqlplpgsqlreturn-query

Read More
PostgreSQL: ERROR: 42601: a column definition list is required for functions returning "record&...

sqldatabasepostgresqlplpgsqlset-returning-functions

Read More
How to return result of a SELECT inside a function in PostgreSQL?...

sqldatabasepostgresqlplpgsqlreturn-query

Read More
It could refer to either a PL/pgSQL variable or a table column...

databasepostgresqlplpgsqlpgadmin

Read More
How to create function that returns nothing...

databasepostgresqlplpgsqlvoid

Read More
Are plpgsql functions atomic?...

databasepostgresqlplpgsqlatomic

Read More
How to write function for optional parameters in PostgreSQL?...

sqldatabasepostgresqlplpgsql

Read More
PostgreSQL: Query has no destination for result data...

sqldatabasepostgresqlplpgsql

Read More
RETURN cannot have a parameter in function with OUT parameters...

sqldatabasepostgresqlplpgsql

Read More
LANGUAGE SQL vs LANGUAGE plpgsql in PostgreSQL functions...

sqldatabasepostgresqlplpgsql

Read More
plpgsql: No function matches the given name and argument types. You might need to add explicit type ...

sqldatabasepostgresqlplpgsql

Read More
`SELECT INTO` multiple variables in PostgreSQL...

sqldatabasepostgresqlplpgsqlselect-into

Read More
Dynamic SQL with EXECUTE and nested format()...

postgresqlplpgsqlcommon-table-expressiondynamic-sql

Read More
Looping in PL/pgSQL to insert rows from multiple unnested arrays?...

sqlpostgresqlplpgsql

Read More
Declare row type variable in PL/pgSQL...

postgresqltypesplpgsqldeclareselect-into

Read More
DROP FUNCTION without knowing the number/type of parameters?...

sqlpostgresqlplpgsqldynamic-sqlddl

Read More
How to sort objects in a JSON array by an object property?...

jsonpostgresqlsql-order-byplpgsqljsonb

Read More
PostgreSQL - return a record[] from a plpgsql function...

sqldatabasepostgresqlplpgsqlrecordtype

Read More
How to create sequence which start from 1 in each day...

sqlpostgresqlplpgsqlpostgresql-9.1

Read More
How to create an array from variables in postgresql?...

arrayspostgresqlplpgsql

Read More
Using a prepared statement in a stored function in PostgreSQL...

databasepostgresqlfunctionprepared-statementplpgsql

Read More
How to return a boolean after inserting within a postgres function?...

sqlpostgresqlplpgsql

Read More
Return dynamically generated SQL query in plpgsql...

sqlpostgresqlplpgsql

Read More
ERROR: function ... does not exist and HINT: No function matches the given name and argument types...

sqldatabasepostgresqlplpgsql

Read More
Can i update a table structure and access it in a plpgsql function?...

postgresqlfunctionplpgsql

Read More
BackNext