Обсуждение: query

Поиск
Список
Период
Сортировка

query

От
Hector Galicia
Дата:
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