Re: SELECT clause without parameters - Mailing list pgsql-general

From Albe Laurenz
Subject Re: SELECT clause without parameters
Date
Msg-id A737B7A37273E048B164557ADEF4A58B50F92BF9@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to SELECT clause without parameters  (pinker <pinker@onet.eu>)
List pgsql-general
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

pgsql-general by date:

Previous
From: pinker
Date:
Subject: SELECT clause without parameters
Next
From: Zdeněk Bělehrádek
Date:
Subject: How to EXPLAIN a trigger function