Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in set-returning-functions

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

PostgreSQL function returns one column instead of 4 columns [duplicate]

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

Change a date range into new rows with discrete dates

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

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's the proper index for querying structures in arrays in Postgres jsonb?

Unnest multiple arrays in parallel