Intersect and order by - Mailing list pgsql-general

From Michaël Fiey
Subject Intersect and order by
Date
Msg-id 006b01c0a1b0$8c3b81c0$6400a8c0@pc03
Whole thread Raw
Responses Re: Intersect and order by  (Michael Fork <mfork@toledolink.com>)
Re: Intersect and order by  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

I don't understand what's happening with my command
I read postgresql docs, it should work...What's the problem ?
The command is :

select col1
from table
where <conditions 1>
intersect
select col1
from table
where <conditions 2>
order by col1

It does not work and return "get_sortgroupclause_expr: ORDER/GROUP BY
expression not found in targetlist"

I use pgsql 7.03 ont redhat 7.0.

Any help would be appreciated

michael




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slowdown problem when writing 1.7million records
Next
From: Bruce Momjian
Date:
Subject: Re: Slowdown problem when writing 1.7million records