Postgres Pro
Downloads
Home   >   mailing lists

Re: Definition of return types for own functions? - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Definition of return types for own functions?
Date
Msg-id 20060928081519.GD14250@a-kretschmer.de
Whole thread Raw
In response to Definition of return types for own functions?  (Matthias.Pitzl@izb.de)
Responses Re: Definition of return types for own functions?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
am  Thu, dem 28.09.2006, um  9:46:29 +0200 mailte Matthias.Pitzl@izb.de folgendes:
> Hello all!
>
> Is it possible to define a complex return type like a record in a function
> without having some table around with the needed structure of the return
> values?

Yes, you can define a new type:

CREATE TYPE name AS
    ( attribute_name data_type [, ... ] )



HTH, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Full Text fuzzy search
Next
From: Joachim Wieland
Date:
Subject: Re: cyclical redundancy checksum algorithm(s)?