Re: postgresql referencing and creating types as record

On Thu, Aug 7, 2014 at 11:50 PM, vpmm2007 <vaishalim2007(at)gmail(dot)com> wrote:
> 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));

Looks like something like:

CREATE TYPE LT_PAYMENT AS
(
BASIC numeric,
DP numeric,
GRADE_PAY numeric
);

CREATE TYPE TYPE_CALC_TAX AS
(
FIN_ROLE_ID numeric(8),
CALC_FOR_ROLE_CODE numeric(8)
);

CREATE OR REPLACE FUNCTION some_function() RETURNS LT_PAYMENT AS
$$
...
$$ LANGAUGE PLPGSQL;

I'd be studying the pl/pgsql documentation and the data type
differences (for number, you'd want to use int, numeric, or float8
depending on circumstances).

merlin