Re: 94 ignores missing selectlist

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