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

Re: [GENERAL] Converting SQL to pg

In article d960cb61b694cf459dcfb4b0128514c203937...@exadv11.host.magwien.gv.at, Albe Laurenz laurenz.a...@wien.gv.at 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

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,

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