94 ignores missing selectlist - Mailing list pgsql-hackers

From Erik Rijkers
Subject 94 ignores missing selectlist
Date
Msg-id e2b279aee920e74832f3325596e12e75.squirrel@webmail.xs4all.nl
Whole thread Raw
Responses Re: 94 ignores missing selectlist  (Marko Tiikkaja <marko@joh.to>)
List 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
---123
(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









pgsql-hackers by date:

Previous
From: Jeevan Chalke
Date:
Subject: Re: [PATCH] Filter error log statements by sqlstate
Next
From: Marko Tiikkaja
Date:
Subject: Re: 94 ignores missing selectlist