Re: postgres cust types

2015-02-03 13:49 GMT+01:00 Ramesh T <rameshparnanditech@gmail.com>:

Hi ,

      i created type on postgres

                             CREATE  TYPE order_list AS (order_id bigint);

it works fine.

then, i try to create a other table type using above created type.

like,

--create or replace type suborder_list_table as table of suborder_list;

this on oracle formate 

This syntax is not supported in Pg - resp. a collections are not supported by PostgreSQL.

use a arrays instead

DECLARE array_var order_list[];

http://www.postgresql.org/docs/9.4/static/arrays.html

Regards

Pavel Stehule

 

i need to convert postgres and how to create a table type in postgres is it possible

or 

else any other method.

FYI,i am using these types in a function.

thanks in advance,