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.klaver@aklaver.com