Re: DELETE with JOIN

On Thu, Aug 7, 2008 at 5:37 PM, <felix(at)crowfix(dot)com> wrote:
> On Thu, Aug 07, 2008 at 06:12:32PM -0400, Alvaro Herrera wrote:
>
>> I suggest you do not assume that Oracle implementation details apply to
>> Postgres, because they do not, most of the time. They certainly don't
>> in this case.
>
> And I suggest you go back and read where I said I had to do this on
> several databases and am trying to avoid custom SQL for each one. I
> would much rather this were postgresql only, but it's not.

My experience with Oracle and PostgreSQL together tell me that you're
better off researching a proper method for each db independent of the
other. While it may be possible to come with a generic method that
works well in both dbs for a lot of things, this doesn't look like one
of them.