| 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: | Whole Thread | Raw Message | 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 |