pgsql-hackers:
The following is Oracle's PL/SQL
if resTypeTableName is null
then
queryStr := 'select IntIID, Path FROM aaResourceData' || ' where
ResType=''' || srcType || ''' and ResID=''' || srcID || '''';
else
queryStr := 'select
IntIID, Path FROM ' || resTypeTableName || ' where ResType=''' || srcType ||
''' and ResID=''' ||
srcID || '''';
end if;
open cursorSrc for queryStr;
Here queryStr is a variable which type is TEXT OR VARCHAR or other string types.
But in PLPGSQL, we can only open a cursor this way:
open cursorSrc for select * from testtable;
We cannot substitude "select * from testtable" with a variable.
Is there another way to handle it?
Thank you for your help. :-)
billy
[EMAIL PROTECTED]
2008-06-13
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
