From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Ing. Jhon Carrillo <jdigital@cantv.net>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Function .. AS..?
Date: Wed, 9 Feb 2005 22:06:07 -0800 (PST)
Message-ID: <20050209220435.D62999@megazone.bigpanda.com> (raw)
In-Reply-To: <014201c50ee9$eee0dcd0$1400a8c0@tgusta2>
References: <014201c50ee9$eee0dcd0$1400a8c0@tgusta2>
On Wed, 9 Feb 2005, Ing. Jhon Carrillo wrote:
> Those instructions are good but i want to call this function only for "
> select consulta_contacto(1)" nothing more, Is really necesary to use
> "AS ..."?
If it absolutely needs to be setof record, yes.
It may be more appropriate to make a composite type with CREATE TYPE AS
and then make the function return SETOF <newtypename> instead.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone.bigpanda.com, jdigital@cantv.net, pgsql-hackers@postgresql.org
Subject: Re: Function .. AS..?
In-Reply-To: <20050209220435.D62999@megazone.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox