Questions
Linux
Laravel
Mysql
Ubuntu
Git
Menu
HTML
CSS
JAVASCRIPT
SQL
PYTHON
PHP
BOOTSTRAP
JAVA
JQUERY
R
React
Kotlin
×
Linux
Laravel
Mysql
Ubuntu
Git
New posts in set-returning-functions
Access and return result from INSERT INTO in PL/pgSQL function
Dec 25, 2022
postgresql
plpgsql
set-returning-functions
sql-returning
set-valued function called in context that cannot accept a set
Oct 20, 2022
postgresql
plpgsql
set-returning-functions
Postgres function returning one record while I have many records?
Sep 22, 2022
sql
postgresql
postgresql-9.1
plpgsql
set-returning-functions
How to get elements with a unique number from a json array in PostgreSQL?
Oct 29, 2022
arrays
json
postgresql
jsonb
set-returning-functions
PostgreSQL - order by an array
Nov 21, 2022
sql
postgresql
sql-order-by
aggregate
set-returning-functions
NULL emements lost when casting result of unnest()
Jul 31, 2021
arrays
postgresql
casting
unnest
set-returning-functions
How to return a table's rowtype plus an additional column from a function?
Feb 21, 2022
postgresql
plpgsql
return-type
set-returning-functions
Error while using regexp_split_to_table (Amazon Redshift)
Aug 30, 2022
amazon-redshift
set-returning-functions
Split string with two delimiters and convert type
Sep 05, 2022
postgresql
plpgsql
set-returning-functions
JOIN on set returning function results
Apr 16, 2018
sql
postgresql
join
set-returning-functions
lateral
Remove braces from regular expression result
Oct 24, 2022
arrays
regex
postgresql
plpgsql
set-returning-functions
SQL multiple UNNEST in single select list
Feb 27, 2022
sql
postgresql
unnest
set-returning-functions
Parallel unnest() and sort order in PostgreSQL
Sep 05, 2021
sql
postgresql
postgresql-9.3
unnest
set-returning-functions
What is the expected behaviour for multiple set-returning functions in SELECT clause?
Feb 10, 2022
sql
postgresql
cross-join
generate-series
set-returning-functions
Use Values from JSONB Array inside a WHERE IN Clause
Nov 17, 2022
arrays
postgresql
where
jsonb
set-returning-functions
How to select multiple rows filled with constants in Amazon Redshift?
Apr 14, 2022
sql
postgresql
amazon-redshift
set-returning-functions
Function to loop through and select data from multiple tables
Nov 06, 2022
postgresql
for-loop
plpgsql
dynamic-sql
set-returning-functions
Postgresql generate_series of months
Feb 28, 2016
sql
postgresql
time-series
generate-series
set-returning-functions
What's the proper index for querying structures in arrays in Postgres jsonb?
Sep 11, 2022
sql
postgresql
indexing
set-returning-functions
jsonb
Unnest multiple arrays in parallel
Nov 17, 2021
arrays
postgresql
arraylist
plpgsql
set-returning-functions
Older Entries »