Re: [GENERAL] Curious why planner can't handle NOT IN

On May 3, 2013 12:15 PM, Yang Zhang yanghates...@gmail.com wrote: I have an `account` table with 5.3M rows, with primary key `id` of type `text` (and 600+ columns if that matters). I'm trying to create a `newaccount` table with the same schema but 600k newly imported rows, then insert all

Re: [GENERAL] Aggregate functions not allowed in WHERE clause

i think this query can be rewritten as SELECT claim_id,sum(invoices),sum(payments) FROM logs GROUP BY claim_id HAVING sum(invoices) 0 OR sum(payments) 0; having clause can be used with aggregate functions but those functions should be the part of column list/expression list in the SELECT

[GENERAL] after insert trigger hangs

? pradeep singh __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster