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(dot)klaver(at)aklaver(dot)com