Στις Wednesday 24 February 2010 15:34:48 ο/η Louis-David Mitterrand έγραψε:
> Here is a test case I built. I want to list all cruises by cruise_type
> but after merging cruise_type that have the same cruise_type_name:
>
> drop table cruise;
> drop table cruise_type;
>
> create table cruise_type
On Wed, Feb 24, 2010 at 02:09:09PM +0100, A. Kretschmer wrote:
> In response to Louis-David Mitterrand :
> > 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 err
In response to Louis-David Mitterrand :
> 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(t
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,
--
S
