Lists: | pgsql-hackers |
---|
From: | "Erik Rijkers" <er(at)xs4all(dot)nl> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | 94 ignores missing selectlist |
Date: | 2014-01-30 09:44:06 |
Message-ID: | e2b279aee920e74832f3325596e12e75.squirrel@webmail.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
This seems wrong: in HEAD, an empty select list does *not* generate a error warning anymore:
$ psql -X
psql (9.4devel_HEAD_20140130_0805_571addd)
Type "help" for help.
testdb=# create table t as select i from generate_series(1,3) as f(i);
SELECT 3
testdb=# select * from t;
i
---
1
2
3
(3 rows)
testdb=# select from t;
--
(3 rows)
Surely the behaviour of v9.3, which complains healthily with:
ERROR: syntax error at or near "from"
LINE 1: select from t;
is to be preferred.
thanks,
Erik Rijkers
From: | Marko Tiikkaja <marko(at)joh(dot)to> |
---|---|
To: | Erik Rijkers <er(at)xs4all(dot)nl>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: 94 ignores missing selectlist |
Date: | 2014-01-30 09:51:17 |
Message-ID: | 52EA2095.7060605@joh.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 1/30/14, 10:44 AM, Erik Rijkers wrote:
> This seems wrong: in HEAD, an empty select list does *not* generate a error warning anymore:
This is intentional, see 1b4f7f93b4693858cb983af3cd557f6097dab67b
Regards,
Marko Tiikkaja