Li
Li
## Enhancement A table function is a user-defined PL/SQL function that returns a collection of rows, but PL/iSQL is not support now. Recommend to support table function and pipelined table...
## Enhancement PL/iSQL not support is table of in package. ```sql postgres=# create or replace package pkg as type numset is table of number; end; / ERROR: syntax error at...
When execute the follow sql. ```sql select * from ( select tt.* from ( select * from dt2 order by a) as tt ) as t ; ``` Subquery with...
## Bug Report Meet a bug in plisql package when define a ref cursor. ```sql create table t1(a int, b int); -- in public schema -- create package create or...
## Enhancement PL/iSQL not support %type reference package variable. ```sql -- create table t1 postgres=# create table t1(a int, b int); CREATE TABLE -- create package postgres=# create or replace...