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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
