Re: [SQL] bug in 9.2.2 ? subquery accepts wrong column name : upd

2013-03-15 Thread Achilleas Mantzios
Thanx Tom. On Πεμ 14 Μαρ 2013 12:17:46 Tom Lane wrote: > Achilleas Mantzios writes: > > dynacom=# SELECT DISTINCT ON (qry.setid) qry.setid, qry.arragg[1:2] FROM > > (select distinct sst.setid,(array_agg(vsl.name) OVER (PARTITION BY > > sst.setid ORDER BY character_length(vsl.name))) a

Re: [SQL] bug in 9.2.2 ? subquery accepts wrong column name : upd

2013-03-14 Thread Tom Lane
Achilleas Mantzios writes: > dynacom=# SELECT DISTINCT ON (qry.setid) qry.setid, qry.arragg[1:2] FROM > (select distinct sst.setid,(array_agg(vsl.name) OVER (PARTITION BY > sst.setid ORDER BY character_length(vsl.name))) as arragg > FROM sissets sst, vessels vsl WHERE vsl.id=sst.vsl

[SQL] bug in 9.2.2 ? subquery accepts wrong column name : upd

2013-03-14 Thread Achilleas Mantzios
dynacom=# SELECT DISTINCT ON (qry.setid) qry.setid, qry.arragg[1:2] FROM (select distinct sst.setid,(array_agg(vsl.name) OVER (PARTITION BY sst.setid ORDER BY character_length(vsl.name))) as arragg FROM sissets sst, vessels vsl WHERE vsl.id=sst.vslid ORDER BY sst.setid) as qry