Re: [GENERAL] postgresql referencing and creating types as record

2014-08-12 Thread Merlin Moncure
On Thu, Aug 7, 2014 at 11:50 PM, vpmm2007 wrote: > create or replace package CUM_A_TYPES > as > type LT_PAYMENT is record > (BASICnumber, > DPnumber, > GRADE_PAYnumber > ); > TYPE TYPE_CALC_TAX is record > ( > FIN_ROLE_ID number(8), > CALC_FOR_ROLE_CODE number(

Re: [GENERAL] postgresql referencing and creating types as record

2014-08-11 Thread Adrian Klaver
On 08/10/2014 09:50 PM, Vaishali Maheshkar wrote: SIR, THANKS FOR YOUR REPLY , CCing list. actually i m trying to create record type data in postgres , but i cant declare it directly as in oracle my purpose is to create types of record type in oracle it was done by creating a package and d

[GENERAL] postgresql referencing and creating types as record

2014-08-11 Thread vpmm2007
type function is record (f1 NUMERIC,f2 NUMERIC..); this is in oracle kindly tell me what is the substitute to use "is record " in postgres. its urgent . thanks and rgds vpmm -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-referencing-and-creating-type

Re: [GENERAL] postgresql referencing and creating types as record

2014-08-09 Thread Adrian Klaver
On 08/07/2014 09:50 PM, vpmm2007 wrote: create or replace package CUM_A_TYPES as type LT_PAYMENT is record (BASICnumber, DPnumber, GRADE_PAYnumber ); TYPE TYPE_CALC_TAX is record ( FIN_ROLE_ID number(8), CALC_FOR_ROLE_CODE number(4)); NEED TO CONVERT TH

Re: [GENERAL] postgresql referencing and creating types as record

2014-08-08 Thread vpmm2007
create or replace package CUM_A_TYPES as type LT_PAYMENT is record (BASICnumber, DPnumber, GRADE_PAYnumber ); 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

Re: [GENERAL] postgresql referencing and creating types as record

2014-08-08 Thread Adrian Klaver
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 (BASICnumber, DPnumber, GRADE_PAYnumber ); TYPE TYPE_CALC_TAX is record ( FIN_ROLE_ID number(8), CALC_FOR_ROLE_C

Re: [GENERAL] postgresql referencing and creating types as record

2014-08-07 Thread vpmm2007
In reply to this post by vpmm2007 create or replace package CUM_A_TYPES as type LT_PAYMENT is record (BASICnumber, DPnumber, GRADE_PAYnumber ); TYPE TYPE_CALC_TAX is record ( FIN_ROLE_ID number(8), CALC_FOR_ROLE_CODE number(4)); NEED TO CONVERT THIS TO POSTGRE

Re: [GENERAL] postgresql referencing and creating types as record

2014-08-06 Thread David G Johnston
vpmm2007 wrote > type function is record (f1 NUMERIC,f2 NUMERIC..); this is in oracle > > kindly tell me what is the substitute to use "is record " in postgres. > > its urgent . > > thanks and rgds > vpmm No idea on exactly what Oracle is creating here (a type or a set returning function)