Postgres Pro
Downloads
Home   >   mailing lists

AW: [HACKERS] distinct. Is this the correct behaviour? - Mailing list pgsql-hackers

From Zeugswetter Andreas IZ5
Subject AW: [HACKERS] distinct. Is this the correct behaviour?
Date
Msg-id 219F68D65015D011A8E000006F8590C60339E14C@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: [HACKERS] distinct. Is this the correct behaviour?  (Vince Vielhaber <vev@michvhf.com>)
List pgsql-hackers
Tree view 
>     select distinct f1 from t1 order by f2;
> 
> Returned the following message under Oracle8 on NT:
>     ORA-01791: not a SELECTed expression

Informix:    309: ORDER BY column (f2) must be in SELECT list. 

Andreas

pgsql-hackers by date:

Previous
From: "Paul Becker"
Date:
Subject: RE: [DOCS] Re: [HACKERS] Outline for PostgreSQL book
Next
From: Vince Vielhaber
Date:
Subject: Re: AW: [HACKERS] distinct. Is this the correct behaviour?