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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных