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

List:       postgresql-general
Subject:    [HACKERS] a problem when poring from Oracle's PL/SQL to PLPGSQL
From:       "billy" <billywq () 163 ! com>
Date:       2008-06-13 8:39:59
Message-ID: 48523283.014507.00758 () m5-81 ! 163 ! com
[Download RAW message or body]

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
　　　　　　　　billywq@163.com
　　　　　　　　　　2008-06-13




-- 
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]