query - Mailing list pgsql-general

From Hector Galicia
Subject query
Date
Msg-id 20021009164053.8412.qmail@web9602.mail.yahoo.com
Whole thread Raw
List pgsql-general
this are parameters for my function

select test('>=','3000.00');

in my function I'm trying to make a dinamic query,
like this one

OPEN curs2 FOR EXECUTE "SELECT column1,  column2,
amount FROM table1 where amount  " || $1 || " " || $2
|| ";

but I'm not sure if a operator can be a parameter, it
is posible?

thanks

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Point in Time Recovery WAS: Hot Backup
Next
From: "scott.marlowe"
Date:
Subject: Re: access time performance problem