On 2012-09-18, Rafal Pietrak <ra...@zorro.isa-geek.com> wrote: > > Actual Tom's example(1): > SELECT 1/x AS inverse FROM data WHERE x <> 0; > extended to (2): > SELECT 1/x AS inverse FROM data WHERE x <> 0 AND 1/x > 20; > could be written by user as (3): > SELECT 1/x AS inverse FROM data WHERE x <> 0 AND inverse > 20; > but token/replaced to its form (2) before WHERE evaluation.
Macros are confusing: select random()*10 as confusion from generate_series(1,10) where confusion > 5; -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
