SELECT clause without parameters

Started by pinkerover 10 years ago2 messagesgeneral
Jump to latest
#1pinker
pinker@onet.eu

I would like to ask what's the reason of change SELECT behaviour.
In distributions below 9.4 SELECT without any parameters caused a syntax
error and now gives empty set. Was it made for some bigger aim ? :)

for instance 8.4:
postgres=# select version();
version
-----------------------------------------------------------------------------------------------------
PostgreSQL 8.4.17 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 32-bit
(1 wiersz)

postgres=# select
postgres-# ;
ERROR: syntax error at or near ";"
LINIA 2: ;

and 9.4:
psql (9.4.4)
Type "help" for help.

postgres=# select
postgres-# ;
--
(1 row)

--
View this message in context: http://postgresql.nabble.com/SELECT-clause-without-parameters-tp5862355.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: pinker (#1)
Re: SELECT clause without parameters

pinker wrote:

I would like to ask what's the reason of change SELECT behaviour.
In distributions below 9.4 SELECT without any parameters caused a syntax
error and now gives empty set. Was it made for some bigger aim ? :)

for instance 8.4:
postgres=# select version();
version
-----------------------------------------------------------------------------------------------------
PostgreSQL 8.4.17 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 32-bit
(1 wiersz)

postgres=# select
postgres-# ;
ERROR: syntax error at or near ";"
LINIA 2: ;

and 9.4:
psql (9.4.4)
Type "help" for help.

postgres=# select
postgres-# ;
--
(1 row)

That must be this change:
/messages/by-id/E1Vs0Qu-0004bC-6E@gemulon.postgresql.org

The explanation is in the commit message.

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general