query

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

Browse pgsql-general by date

  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