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

From Ken Tanzer
Subject Re: Intersection or zero-column queries
Date
Msg-id CAD3a31UFadYc9QiZwe9A8it_=zBmXz=mK3=Mqe-rkzrV7N+pQQ@mail.gmail.com
Whole thread Raw
In response to Re: Intersection or zero-column queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Intersection or zero-column queries
List pgsql-general
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.

Cheers,
Ken

--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X
Next
From: Hans Schou
Date:
Subject: Re: Deadlock with one table - PostgreSQL is doing it right