[SQL] Wrong query plan when using a left outer join

2012-01-16 Thread Feike Steenbergen
I have the following setup: A table called hand: Table "stage.hand_meta" Column | Type | Modifiers ---+--+- hand_id | integer

[SQL] UPDATE COMPATIBILITY

2012-01-16 Thread Gera Mel Handumon
What version of postgresql that the update compatibility below will be implemented? UPDATE COMPATIBILITY UPDATE accounts SET (contact_last_name, contact_first_name) = (SELECT last_name, first_name FROM salesmen WHERE salesmen.id = accounts.sales_id); TIA, -- Gera Mel E. Handumon --

Re: [SQL] Token separation

2012-01-16 Thread Tim Landscheidt
Tom Lane wrote: >> [ "0x13" is lexed as "0" then "x13" ] >> Is this behaviour really conforming to the standard? > Well, it's pretty much the universal behavior of flex-based lexers, > anyway. A token ends when the next character can no longer sensibly > be added to it. I know, but - off the