Re: Intersection or zero-column queries - Mailing list pgsql-general

From Tom Lane
Subject Re: Intersection or zero-column queries
Date
Msg-id 19206.1513955336@sss.pgh.pa.us
Whole thread Raw
In response to Re: Intersection or zero-column queries  (Ken Tanzer <ken.tanzer@gmail.com>)
List pgsql-general
Ken Tanzer <ken.tanzer@gmail.com> writes:
> I noticed I get this behavior in 9.6, but in 9.2 an empty select results in
> a syntax error.  Which just got me curious what caused the change, if it
> was deliberate, and if one or the other is more proper behavior.

Yes, it was an intentional change, see
https://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=1b4f7f93b

There should be something about it in the 9.4 release notes.

            regards, tom lane


pgsql-general by date:

Previous
From: rihad
Date:
Subject: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices
Next
From: rihad
Date:
Subject: Re: pg_upgrading to 10.1 corrupts (varchar,varchar) UNIQUE indices