Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in set-returning-functions

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

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

Postgres function returning one record while I have many records?

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

PostgreSQL - order by an array

NULL emements lost when casting result of unnest()

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

Error while using regexp_split_to_table (Amazon Redshift)

Split string with two delimiters and convert type

JOIN on set returning function results

Remove braces from regular expression result

SQL multiple UNNEST in single select list

Parallel unnest() and sort order in PostgreSQL

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

Use Values from JSONB Array inside a WHERE IN Clause

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

Function to loop through and select data from multiple tables

Postgresql generate_series of months

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

Unnest multiple arrays in parallel