2015-02-03 13:49 GMT+01:00 Ramesh T <rameshparnandit...@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, > > > >
