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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
