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

The explanation is in the commit message.

Yours,
Laurenz Albe