| From: | otter117(at)yahoo(dot)de |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | undocumented feature or bug in subquery : psql (PostgreSQL) 9.4.6 on SLES12 SP1 |
| Date: | 2016-08-25 16:29:00 |
| Message-ID: | 20160825162900.15675.78433@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/static/functions-subquery.html
Description:
psql (PostgreSQL) 9.4.6 on SLES12 SP1
2 tables a and b
Table "public.a"
Column | Type | Modifiers
-----------------+--------------------------+---------------
foo | integer | not null
bar | integer | not null
Table "public.b"
Column | Type | Modifiers
-----------------+--------------------------+---------------
bar | integer | not null
No error when executing this statement even though table b does not contain
column foo
SELECT foo,bar FROM a WHERE foo=1 AND bar NOT IN (SELECT bar FROM b WHERE
bar > 2 AND foo=2)
Get an error on this one ERROR: column b.foo does not exist
SELECT foo,bar FROM a WHERE foo=1 AND bar NOT IN (SELECT bar FROM b WHERE
b.bar > 2 AND b.foo=2)
It works if I remove foo from the subquery.
SELECT foo,bar FROM a WHERE foo=1 AND bar NOT IN (SELECT bar FROM b WHERE
b.bar > 2)
Do I need to qualify all columns in the subquery or is this a bug is psql
9.4.6?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-08-25 16:33:01 | Re: Order of Operations for Update Command |
| Previous Message | jens.timmerman | 2016-08-25 15:35:17 | does md5 really help against sniffing? |