| From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
|---|---|
| To: | "'hackers(at)postgresql(dot)org'" <hackers(at)postgreSQL(dot)org> |
| Subject: | Re: AW: [HACKERS] distinct. Is this the correct behaviour? |
| Date: | 1999-10-21 15:09:50 |
| Message-ID: | Pine.BSF.4.05.9910211108470.314-100000@paprika.michvhf.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, 21 Oct 1999, Zeugswetter Andreas IZ5 wrote:
> > 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.
The version of sybase I tried earlier was 4.9.2. I just tried it
again on 11.5 -- same thing.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> Have you seen http://www.pop4.net?
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vince Vielhaber | 1999-10-21 15:31:56 | Re: [HACKERS] GPL vs BSD licencing - a new twist |
| Previous Message | Lamar Owen | 1999-10-21 15:09:37 | Re: [DOCS] Re: [HACKERS] Outline for PostgreSQL book |