From: | Juan Francisco Diaz <j-diaz(at)publicar(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Badly placed ()'s |
Date: | 2003-09-24 12:52:19 |
Message-ID: | BB96FDB3.B6E%j-diaz@publicar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi, i have this function:
DECLARE
cadena VARCHAR;
Libro ALIAS FOR $1;
numIni ALIAS FOR $2;
numFin ALIAS FOR $3;
res orden%ROWTYPE;
BEGIN
IF numIni <> 0 THEN
cadena := ''select * from orden where idOrden not in (select
idOrden from orden where idlibro = '';
cadena := cadena || Libro;
cadena := cadena || '' order by idorden limit '';
cadena := cadena || numIni;
cadena := cadena || '') and idlibro = '';
cadena := cadena || Libro;
cadena := cadena || '' order by idorden limit '';
cadena := cadena || numFin-numIni;
cadena := cadena || '';'';
ELSE
cadena := ''select * from orden where idlibro = '' || Libro ||
'' order by idorden limit '' || numFin || '';'';
END IF;
RAISE NOTICE ''%'',cadena;
FOR res IN EXECUTE cadena LOOP
RETURN NEXT res;
END LOOP;
return;
END;
And I get the error of badly placed ()'s... What is wrong?
Thanks
JuanF
'a very tired newbie'
From | Date | Subject | |
---|---|---|---|
Next Message | simon | 2003-09-24 13:30:22 | Learning pl/pgsql - good sources? |
Previous Message | Heath Tanner | 2003-09-24 02:03:23 | Re: Concatenating |