From: | Hector Galicia <hgaliciac(at)yahoo(dot)com> |
---|---|
To: | Base de datos <pgsql-general(at)postgresql(dot)org> |
Subject: | query |
Date: | 2002-10-09 16:40:53 |
Message-ID: | 20021009164053.8412.qmail@web9602.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2002-10-09 16:46:09 | Re: access time performance problem |
Previous Message | scott.marlowe | 2002-10-09 16:19:26 | Point in Time Recovery WAS: Hot Backup |