Re: Function .. AS..? - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: Function .. AS..?
Date
Msg-id 20050209220435.D62999@megazone.bigpanda.com
Whole thread Raw
In response to Function .. AS..?  ("Ing. Jhon Carrillo" <jdigital@cantv.net>)
List pgsql-hackers
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.


pgsql-hackers by date:

Previous
From: "Ing. Jhon Carrillo"
Date:
Subject: Function .. AS..?
Next
From: Michael Fuhr
Date:
Subject: Re: [SQL] Function .. AS..?