Re: PARAMETERS IN QUERIES

I Think that he's a talking about that Oracle like Query:
BEGIN;
A = 1;
select * from test where id = a;
a := a + 1;
select * from test where id = a;
COMMIT;

The way to do it in Postgres is using function.

Rafael

On Mon, Feb 23, 2009 at 8:17 PM, Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> wrote:

>
>
> On Mon, Feb 23, 2009 at 5:56 PM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>wrote:
>
>> Where can I find information about how to use parameters in queries? For
>> example, to define parameters in the WHERE clause to build dynamic SELECT's.
>>
>> I have searched the documentation manual but I cannot find this specific
>> topic.
>>
>>
>
> What interface are you using to construct the queries? Or are you talking
> about pl/pgsql? Can you clarify what you are trying to do?
>
> Sean
>
>
>