Re: [SQL] switching default integer datatype to int8 and "IN (...)"

Thanks Andy - this "solves" the problem(*1) on the first level, where I know how to quote the params, so they must be evaluated / casted. But when I get into the subselects, I don't know how to make postgres to cast / evaluate the results of the subselect, so it again does only sequential scan

Re: [SQL] Getting sequence value after inserting many rows at a time

On Sat, Jan 11, 2003 at 12:25:47 -0600, Maurício Sessue Otta <[EMAIL PROTECTED]> wrote: > Hi, > > I have a PHP script that do something like > this: > > INSERT INTO table_with_sequence (field1, > field2, fieldn) > SELECT field1, field2, ..., fieldn FROM table,table > > WHERE condition