Re: postgres cust types

On 02/03/2015 07:50 AM, Ramesh T wrote:

Am CCing the list.

> CREATE TYPE order_list AS (order_id bigint);
> i created above type

Not sure that the above does anything.

>
> and i am using order_list, trying creating table type (datatype)
>
> *create or replace type order_list_table as table of order_list;*
>
> it is in oracle formate i need to convert this into postgres type.
>
>
> why because i am using order_list_table in function to gather setof
> values return by function.

Except in the below you are using another type?

>
> sample program ,
> create or replace FUNCTION choose(
> id1 IN bigint,
> id2 IN bigint,
> id3 IN character(2))
> RETURNS suborder_list_table
> IS
> v_ret suborder_list_table;
>
>
> here i'm using v_ret for return set of values to return..

Not sure what you are trying to do. Might want to take a look at:

http://www.postgresql.org/docs/9.3/interactive/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS

In particular the RETURNS TABLE example.

>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com