Re: postgresql referencing and creating types as record

On 08/07/2014 10:23 PM, vpmm2007 wrote:
>   In reply to this post by vpmm2007
> create or replace package CUM_A_TYPES
> as
>   type LT_PAYMENT is record
> (BASIC    number,
>    DP    number,
>    GRADE_PAY                number
> );
> TYPE TYPE_CALC_TAX is record
>   (
>    FIN_ROLE_ID   number(8),
>    CALC_FOR_ROLE_CODE  number(4));
>
> NEED TO CONVERT THIS TO POSTGRES , ANYBODY PLS HELP ME I M NEW TO POSTGRES

Well you have not provided context for where and how you are using this,
so I will wing it.

 From here:

http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/record_definition.htm

I suspect it is being used in a pl/sql function. In that case Davids
previous pots holds. Look in:

CREATE TYPE
http://www.postgresql.org/docs/9.3/interactive/sql-createtype.html

CREATE FUNCTION
http://www.postgresql.org/docs/9.3/interactive/sql-createfunction.html

pl/pgsql
http://www.postgresql.org/docs/9.3/interactive/plpgsql.html

In particular:

http://www.postgresql.org/docs/9.3/interactive/plpgsql-declarations.html


If you want a more specific answer, we will need more specific information.


> THX&RGDS
> VPMM
>
>
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/postgresql-referencing-and-creating-types-as-record-tp5813901p5814176.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com