X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 6D3BF8B9F24;
	Thu, 10 Feb 2005 06:06:21 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 96257-04; Thu, 10 Feb 2005 06:06:08 +0000 (GMT)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210])
	by svr1.postgresql.org (Postfix) with ESMTP id 205EC8B9CC7;
	Thu, 10 Feb 2005 06:06:08 +0000 (GMT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 8F4F6352C9; Wed,  9 Feb 2005 22:06:07 -0800 (PST)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 74353352B0; Wed,  9 Feb 2005 22:06:07 -0800 (PST)
Date: Wed, 9 Feb 2005 22:06:07 -0800 (PST)
From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: "Ing. Jhon Carrillo" <jdigital@cantv.net>
Cc: pgsql-hackers@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: Function .. AS..?
In-Reply-To: <014201c50ee9$eee0dcd0$1400a8c0@tgusta2>
Message-ID: <20050209220435.D62999@megazone.bigpanda.com>
References: <014201c50ee9$eee0dcd0$1400a8c0@tgusta2>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200502/349
X-Sequence-Number: 64177

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.