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) but either: CREATE TYPE ( ... ) or CREATE FUNCTION ( ... ) RETURNS TABLE ( ... ) The documentation will provide specifics. http://www.postgresql.org/docs/9.3/interactive/sql-commands.html David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/postgresql-referencing-and-creating-types-as-record-tp5813901p5813912.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general