Skip site navigation (1) Skip section navigation (2)

Re: 7.0 release notes should call out incompatible changes more clearly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 7.0 release notes should call out incompatible changes more clearly
Date: 2000-04-03 05:32:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz> writes:
>> 2. SELECT DISTINCT ON syntax has changed --- now need parentheses
>> around the item being DISTINCT'ed.

> I have just upgraded my development machine today and this is proving to
> be a real pain in the neck as I seem to have used this all over the
> place :-)

> Can anyone suggest any syntax that I could use in the interim which will
> be compatible with 7.0 but which will also work with 6.5.3 so that I can
> minimise the pain of upgrading?

Er ... don't use DISTINCT ON?  It's not to be found anywhere in the
SQL92 specs, so if you want to run your app on a variety of DBMSes,
that's your only choice anyway.

If you are a heavy user of DISTINCT ON, I should think you'd gladly
accept a little conversion pain for the benefit of being able to do
DISTINCT ON multiple expressions, instead of only one unadorned
column name.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: HorĂ¡k DanielDate: 2000-04-03 11:51:08
Subject: RE: Call for porting reports
Previous:From: Thomas LockhartDate: 2000-04-03 01:21:22
Subject: Re: Docs refreshed

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group