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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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