Re: Converting SQL to pg

martin(at)cornhobble(dot)com wrote:
> 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)
>
>

Untested, but I imagine it would be something like this.

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

PostgreSQL doesn't have anything similar to IGNORE (afaik), but
depending on what you want to do, you may be able to work around that
with deferred constraints etc.

--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
t: +47 22 85 29 39