Home > mailing lists

join with an array - Mailing list pgsql-sql

From	Louis-David Mitterrand
Subject	join with an array
Date	February 24, 2010 11:40:38
Msg-id	20100224124023.GA16500@apartia.fr Whole thread Raw
Responses	Re: join with an array ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List	pgsql-sql

Tree view

Hi,

I'm trying the following query:
select array_agg(t1.id) from table1 t1 join table2 t2 on (t2.id = any(array_agg)) group by t1.col1;

but I get this error: ERROR:  column "array_agg" does not exist

I tried aliasing array_agg(t1.id) without success.

Thanks for any suggestions,

pgsql-sql by date:

From: Gary Chambers
Date: 22 February 2010, 21:43:35
Subject: Re: Join Advice and Assistance

From: "A. Kretschmer"
Date: 24 February 2010, 12:09:33
Subject: Re: join with an array

join with an array - Mailing list pgsql-sql

Previous

Next