On Mon, Feb 1, 2010 at 12:09 PM, Igor Neyman <[email protected]> wrote: > Original poster asked for the sql that will touch inventory table only > once. > > Your statement (with 3 subqueries) will do it 3 times.
I'm pretty sure that starting with 8.3 the engine will collapse all those into one seq scan internally. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
