set-returning-functions Examples and Free Source Code

How to join generate_series and an array...

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

Return Multiple Values from Oracle Function...

sql oracle-database plsql set-returning-functions

Inconsistent results with jsonb_array_elements_text() twice in the SELECT list...

sql arrays postgresql set-returning-functions

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

sql postgresql join plpgsql set-returning-functions

How do I SELECT multiple values from a function into separate columns?...

sql postgresql set-returning-functions

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

postgresql plpgsql set-returning-functions

Performance of SELECT * in an Inline Table-Valued Function...

sql-server t-sql stored-functions set-returning-functions

Optimize query on big table executing generate_series()...

sql postgresql postgresql-performance generate-series set-returning-functions

Remove braces from regular expression result...

arrays regex postgresql plpgsql set-returning-functions

Call set-returning plpgsql function for each row returned from a query...

arrays postgresql plpgsql set-returning-functions sql-domain

Order by the IN value with jsonb array...

sql arrays postgresql jsonb set-returning-functions

CASE with regexp: "set-valued function called in context that cannot accept a set"...

regex postgresql postgresql-9.0 set-returning-functions

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

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

generate_subscripts(array, 2) returns two records when there is only one multidimensional element...

postgresql multidimensional-array set-returning-functions

Oracle to PostgreSQL query conversion with string_to_array()...

sql oracle-database postgresql set-returning-functions unnest

"ERROR: column ... specified more than once" in VIEW definition...

sql postgresql postgresql-9.4 sql-view set-returning-functions

Error: column does not exist in PostgreSQL...

postgresql pattern-matching set-returning-functions

Unable to execute the function in plpgsql/postgres...

postgresql sql-insert plpgsql set-returning-functions sql-returning

Get each <tag> in String - stackexchange database...

sql postgresql set-returning-functions dataexplorer

Repeat row number of times based on column value...

sql postgresql generate-series set-returning-functions

Create function with SELECT CASE...

sql postgresql plpgsql return-type set-returning-functions

How can I retrieve the set returned from a STR into a model via ecto?...

postgresql elixir ecto set-returning-functions

Return column name and distinct values...

sql postgresql distinct set-returning-functions

Join result of set-returning function (json_array_elements) with table column...

sql json postgresql set-returning-functions

Get even / odd / all numbers between two numbers...

sql postgresql postgresql-9.4 generate-series set-returning-functions

Find duplicated values on array column...

sql arrays postgresql aggregate-functions set-returning-functions

Change a date range into new rows with discrete dates...

sql postgresql generate-series set-returning-functions

How to cast entity to set in PostgreSQL...

sql postgresql generate-series set-returning-functions

How to order query result according to the order of array elements?...

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

Compare result of two table functions using one column from each...

sql postgresql postgresql-9.3 set-returning-functions