Converting SQL to pg

From: <martin(at)cornhobble(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Converting SQL to pg
Date: 2009-07-24 04:42:44
Message-ID: 1248410564.187599@no.spam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I must be tired. Any suggestions on converting the following to postgresql?

UPDATE IGNORE yose5_user_newflags AS flags, yose5_messages AS
msg SET flags.forum_id = msg.forum_id WHERE flags.message_id =
msg.message_id AND flags.message_id IN (15580, 15581, 15706,
15712, 15713, 15719, 15888)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2009-07-24 06:22:29 Re: Search Path vs Synonyms
Previous Message tomrevam 2009-07-24 03:53:41 Re: synchronous_commit=off doesn't always return immediately