On Mon, Feb 1, 2010 at 12:09 PM, Igor Neyman <iney...@perceptron.com> 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
