query

Started by Hector Galiciaover 23 years ago1 messagesgeneral
Jump to latest
#1Hector Galicia
hgaliciac@yahoo.com

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