Re: postgresql referencing and creating types as record - Mailing list pgsql-general

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.