[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [HACKERS] a problem when poring from Oracle's PL/SQL to PLPGSQL
From:       Mario Weilguni <mweilguni () sime ! com>
Date:       2008-06-13 9:03:58
Message-ID: 485237FE.50403 () sime ! com
[Download RAW message or body]

billy schrieb:
> 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. :-)
> 
open cursorSrc for execute queryStr; should work fine

Regards
Mario Weilguni


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers


[prev in list] [next in list] [prev in thread] [next in thread]