Re: Intersection or zero-column queries

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Victor Yegorov <vyegorov(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Intersection or zero-column queries
Date: 2017-12-22 07:56:23
Message-ID: CAD3a31UFadYc9QiZwe9A8it_=zBmXz=mK3=Mqe-rkzrV7N+pQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hans Schou 2017-12-22 08:05:57 Re: Deadlock with one table - PostgreSQL is doing it right
Previous Message Vincenzo Romano 2017-12-22 07:33:40 Re: [v10] CREATE TEMP FUNCTION/CREATE FUNCTION PG_TEMP.X