set-returning-functions Examples and Free Source Code

Access and return result from INSERT INTO in PL/pgSQL function...

postgresql plpgsql set-returning-functions sql-returning

Repeat rows specified number of times in PostgreSQL...

sql postgresql set-returning-functions

How to join on a nested value from a jsonb column?...

sql postgresql left-join jsonb set-returning-functions

What's the proper index for querying structures in arrays in Postgres jsonb?...

sql postgresql indexing set-returning-functions jsonb

PostgreSQL jsonb_path_query removes result instead of returning null value...

sql postgresql jsonb jsonpath set-returning-functions

Unnest multiple arrays in parallel...

arrays postgresql arraylist plpgsql set-returning-functions

Split given string and prepare case statement...

sql postgresql postgresql-9.3 set-returning-functions unnest

PostgreSQL unnest() with element number...

sql arrays postgresql window-functions set-returning-functions

Split string with two delimiters and convert type...

postgresql plpgsql set-returning-functions

Split column into multiple rows in Postgres...

sql postgresql split set-returning-functions

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

sql database postgresql plpgsql set-returning-functions

Is it safe to use jsonb_array_elements() twice in the same SELECT list?...

postgresql jsonb set-returning-functions

How to return a table's rowtype plus an additional column from a function?...

postgresql plpgsql return-type set-returning-functions

Scope and functionality of table functions...

sql postgresql syntax set-returning-functions

Unnest objects from a jsonb array into separate rows...

sql json postgresql set-returning-functions

Generating Fibonacci sequence with PL/pgSQL function...

sql postgresql plpgsql set-returning-functions

JSONB: more than one row returned by a subquery used as an expression...

sql postgresql postgresql-9.4 jsonb set-returning-functions

Split multi-bracket data (JSON arrays) into rows preserving associations...

sql json postgresql postgresql-14 set-returning-functions

Return table with json...

sql postgresql set-returning-functions

how to send function result to temp table in PostgreSQL...

sql postgresql set-returning-functions

table-valued function in PostreSQL only returning one column...

postgresql set-returning-functions

PL/pgSQL functions: How to return a normal table with multiple columns using an execute statement...

postgresql plpgsql set-returning-functions

Convert function and type Oracle to Postgres...

sql postgresql set-returning-functions

What is the expected behaviour for multiple set-returning functions in SELECT clause?...

sql postgresql cross-join generate-series set-returning-functions

Generate one additional row per array element...

sql postgresql unnest set-returning-functions

Parallel unnest() and sort order in PostgreSQL...

sql postgresql postgresql-9.3 unnest set-returning-functions

How to select multiple rows filled with constants in Amazon Redshift?...

sql postgresql amazon-redshift set-returning-functions

How to return set of new rows in postgres function?...

sql postgresql set-returning-functions

Return a table that already exist in postgresql function...

sql postgresql set-returning-functions

Use Values from JSONB Array inside a WHERE IN Clause...

arrays postgresql where-clause jsonb set-returning-functions