| From: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Subquery uses ungrouped column |
| Date: | 2016-05-26 16:02:15 |
| Message-ID: | 68c84834-70a5-a707-d74a-e0cde953d470@postgrespro.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello!
Why the following query:
SELECT (select msc_id
from collectors
where id = substring(fileid from -1)
) msc_id
from ip_data_records
group by substring(fileid from -1)
gives me:
ERROR: subquery uses ungrouped column "ip_data_records.fileid" from
outer query
LINE 3: where id = substring(fileid from -1)
but the following query:
SELECT (select msc_id
from collectors
where id = fileid
) msc_id
from ip_data_records
group by fileid
is working ok?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-05-26 16:32:34 | Re: Subquery uses ungrouped column |
| Previous Message | Thomas Güttler | 2016-05-26 15:03:25 | Re: Do docs miss information about timing of triggers? |