Why must SELECT DISTINCT, ORDER BY expressions must appear in target list? - Mailing list pgsql-general

From Dave Smith
Subject Why must SELECT DISTINCT, ORDER BY expressions must appear in target list?
Date
Msg-id 1044903874.12742.28.camel@playpen
Whole thread Raw
Responses Re: Why must SELECT DISTINCT, ORDER BY expressions must appear in target list?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
For this query ..

SELECT DISTINCT t0_s.rec_num FROM sample_request t0_s,
 sample_request_line_item t1_li WHERE (t1_li.fulfillment_status =
'Shipped'
AND t1_li.followup_date <= '2003-02-04 20:00:00.000000000+00' AND
(t1_li.customer_prospect_feedback IS NULL OR
t1_li.customer_prospect_feedback = '')) AND
(t0_s.rec_num=t1_li.parentRequest) ORDER BY t0_s.date_of_request DESC


I get this error.

ERROR:  For SELECT DISTINCT, ORDER BY expressions must appear in target
list


This seems like a bug. Why do I need date_of_request in the select
section? SQL Spec?




pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: Re: PostgreSQL x Oracle
Next
From: Tom Lane
Date:
Subject: Re: renaming table leaves constraint behind [7.3.2]