Postgres Pro
Downloads
Home   >   mailing lists

Re: intersect within a subquery - Mailing list pgsql-general

From Tom Lane
Subject Re: intersect within a subquery
Date
Msg-id 25662.1006380150@sss.pgh.pa.us
Whole thread Raw
In response to intersect within a subquery  (Phil Glatz <phil@glatz.com>)
List pgsql-general
Tree view 
Phil Glatz <phil@glatz.com> writes:
> present in two rows in map_flags, so I created a subquery to pull the
> records from map_flags, using INTERSECT.  This query runs by itself ok, but
> when I use it as a subquery, I get parse error at or near "intersect".

You need a newer PG release, evidently.

            regards, tom lane

pgsql-general by date:

Previous
From: Phil Glatz
Date:
Subject: intersect within a subquery
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Version checking when loading psql