Re: [GENERAL] Converting SQL to pg

mar...@cornhobble.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

Re: [GENERAL] Converting SQL to pg

In article , Albe Laurenz wrote: >martin wrote: >To PostgreSQL from what? Mysql unless the person try to port the code made some changes to it. >Can you explain what the statement is supposed to do? It's updating a table of what messages have been read during a thread move. It's part of phoru

Re: [GENERAL] Converting SQL to pg

martin 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,

[GENERAL] Converting SQL to pg

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) -- Se