Thread: SELECT clause without parameters

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.

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:
http://www.postgresql.org/message-id/E1Vs0Qu-0004bC-6E@gemulon.postgresql.org

The explanation is in the commit message.

Yours,
Laurenz Albe