Postgres Pro
Downloads
Home   >   mailing lists

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 1044903491.12751.22.camel@playpen
Whole thread Raw
Responses Re: Why must SELECT DISTINCT, ORDER BY expressions must appear in target list?
List pgsql-general
Tree view 
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: gregbcc@turnstep.com
Date:
Subject: GnuPG / PGP signed MD5 checksums for PostgreSQL 7.3.2, 7.3.1, 7.3, and 7.2.3
Next
From: ¾GÁn©M
Date:
Subject: Can I insert Big5 Chinese from Java servlet(Tomcat) to PostgreSQL 7.3