set-returning-functions Examples and Free Source Code

"INSERT INTO ... FETCH ALL FROM ..." can't be compiled...

postgresql plpgsql postgresql-9.6 database-cursor set-returning-functions

How to display column headers returned by PostgreSQL function?...

sql postgresql set-returning-functions

Combined SELECT from unnested composite type array and regular column...

sql arrays postgresql rowtype set-returning-functions

PostgreSQL - order by an array...

sql postgresql sql-order-by aggregate set-returning-functions

How to get elements with a unique number from a json array in PostgreSQL?...

arrays json postgresql jsonb set-returning-functions

RETURNING rows using unnest()?...

sql database postgresql set-returning-functions sql-returning

JOIN on set returning function results...

sql postgresql join set-returning-functions lateral

Record returned from function has columns concatenated...

sql postgresql join plpgsql set-returning-functions

How do I change the formatting for my return values in this function?...

sql postgresql plpgsql set-returning-functions

Flattening a relation with an array to emit one row per array entry...

sql arrays postgresql set-returning-functions lateral

Create a function that accepts a string and returns multiple rows...

sql postgresql function set-returning-functions create-function

Unnest multiple array columns stored as text in lockstep...

sql postgresql row-number unnest set-returning-functions

Function to loop through and select data from multiple tables...

postgresql for-loop plpgsql dynamic-sql set-returning-functions

Is there a way to add function calls to knex returning or select methods?...

postgresql postgis knex.js geography set-returning-functions

What is the simplest way to return multiple rows from table function in Postgres?...

sql postgresql set-returning-functions

Error while using regexp_split_to_table (Amazon Redshift)...

amazon-redshift set-returning-functions

Create function that returns table doesn't work syntax error? SQL...

sql-server t-sql set-returning-functions

IF NOT EXISTS within a RETURN QUERY statement...

sql postgresql sql-function set-returning-functions

Function returns row type as single value instead of one value per field...

sql postgresql sqlalchemy sql-function set-returning-functions

Postgresql calling a function in another function passing an argument from the main function...

sql postgresql set-returning-functions

Difference Between Querying Table Directly and Querying Function that Returns that Same Table...

postgresql set-returning-functions

why postgres functions returns result in one column?...

sql postgresql select sql-function set-returning-functions

How to return two columns with function...

sql postgresql set-returning-functions

Concatenate columns and adds digits postgresql...

sql postgresql concatenation generate-series set-returning-functions

How to use generate_series() to generate a grid of values...

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

structure of query does not match function result type postgresql...

postgresql plpgsql set-returning-functions

Using set-returning functions in WHERE clauses...

postgresql set-returning-functions

Why do PostgreSQL functions return null columns instead of no rows when the return type is a table n...

postgresql set-returning-functions

How do I fix a Postgres 12 Error: set-returning functions are not allowed in CASE...

sql postgresql postgresql-9.1 set-returning-functions postgresql-12

set-valued function called in context that cannot accept a set...

postgresql plpgsql set-returning-functions