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

Re: Change request ...

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Change request ...
Date: 2007-09-27 10:33:40
Message-ID: 20070927103340.GB13133@svana.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Sep 27, 2007 at 12:15:24PM +0200, Lukas Kahwe Smith wrote:
> >It's been on the TODO list for at least 5 years...
> 
> Wow, I was not aware of this limitation. MySQL hacks around this issue 
> by allowing an ORDER BY in UPDATE (and DELETE) statements.

There is a similar workaround for postgres too, but it's a hack, it
won't work in the general case.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

pgsql-hackers by date

Next:From: Simon RiggsDate: 2007-09-27 11:08:40
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup(MaybeOFFTOPIC)
Previous:From: Lukas Kahwe SmithDate: 2007-09-27 10:15:24
Subject: Re: Change request ...

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