Query optimizer & prepared statements

[Jack Orenstein <jack.orenstein@xxxxxxx>]

If x is an integer column with an index, then

    select ...
    from T
    where x > 1

and

    select ...
    from T
    where x > 1000000000

could be optimized differently. So how is optimization done for a prepared 
statement containing a variable, e.g.

    select ...
    from T
    where x > $1

Jack Orenstein


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general