postgres cust types

From: Ramesh T <rameshparnanditech(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Subject: postgres cust types
Date: 2015-02-03 12:49:48
Message-ID: CAK8Zd=t-3TpH7b0h8xHSHjALqBgJBeUTwVjFwVntcZpVXHOxuA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Holger.Friedrich-Fa-Trivadis 2015-02-03 13:03:25 Re: array in a store procedure in C
Previous Message Juan Pablo L 2015-02-03 04:55:17 Re: array in a store procedure in C