Postgres Pro
Downloads
Home   >   mailing lists

Re: Query optimizer & prepared statements - Mailing list pgsql-general

From Emanuel Calvo Franco
Subject Re: Query optimizer & prepared statements
Date
Msg-id f205bb120906231343y1e6d5c32kd490fe6ac5f2ca9b@mail.gmail.com
Whole thread Raw
In response to Query optimizer & prepared statements  (Jack Orenstein <jack.orenstein@hds.com>)
List pgsql-general
Tree view 
>
>    select ...
>    from T
>    where x > $1
>

prepare testy_prepare(int) as select * from T where x = $1;

execute testy_prepare(4);

Follow the docs :)
http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html


--
              Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
        www.emanuelcalvofranco.com.ar

pgsql-general by date:

Previous
From: Radcon Entec
Date:
Subject: Controlling proliferation of postgres.exe processes
Next
From: Bill Moran
Date:
Subject: Re: Controlling proliferation of postgres.exe processes