LINKDING
Login
Shared bookmarks
Sort by
Added ↑
Added ↓
Title ↑
Title ↓
Apply
Tags
postgresql - Combine a generated series with each row from a select - Database Administrators Stack Exchange
#db
#postgresql
|
The below select is returning an array of all the projects owned by all my users. WITH user_projects AS (SELECT u.id as user_id ,COALESCE(array_agg(DISTINCT pa.project_id), '{0}'::integer[]) as
3 months ago
|
View
Shared by
inhji
Previous
1
Next
User
Everyone
inhji
Apply
Tags
-postgresql
d
b
postgresql - Combine a generated series with each row from a select - Database Administrators Stack Exchange
https://dba.stackexchange.com/questions/77476/combine-a-generated-series-with-each-row-from-a-select
Internet Archive
Tags
#db
#postgresql
Date added
June 24, 2024, 9:22 p.m.
Description
The below select is returning an array of all the projects owned by all my users. WITH user_projects AS (SELECT u.id as user_id ,COALESCE(array_agg(DISTINCT pa.project_id), '{0}'::integer[]) as
