Function .. AS..?

From: "Ing(dot) Jhon Carrillo" <jdigital(at)cantv(dot)net>
To: <pgsql-hackers(at)postgresql(dot)org>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Function .. AS..?
Date: 2005-02-09 20:57:14
Message-ID: 014201c50ee9$eee0dcd0$1400a8c0@tgusta2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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 ..."?

this is the call:

select * from consulta_contacto(1) as (cont_codigo integer,
cont_idpers varchar,
cont_nombre varchar,
cont_apellido varchar,
cont_titulo varchar,
cont_fecnac timestamp ,
cont_codedociv integer,
cont_sexo char(1),
cont_codpais integer,
cont_pw varchar,
cont_empr varchar,
cont_cargo varchar,
cont_pwempr varchar,
cont_aniv char(5),
cont_prof varchar,
cont_trab char(1),
cont_fecgen timestamp,
cont_fecing timestamp,
cont_fuente char(1),
cont_sinc char(1),
cont_codupload integer);

this is the function:

CREATE OR REPLACE FUNCTION consulta_contacto(integer) RETURNS SETOF RECORD AS '
DECLARE
rec RECORD;
sup INTEGER;
BEGIN
FOR rec IN SELECT cont_codigo,cont_idpers, cont_nombre,cont_apellido,cont_titulo,cont_fecnac,cont_codedociv,cont_sexo,cont_codpais,cont_pw,cont_empr,cont_cargo,cont_pwempr,cont_aniv,cont_prof,cont_trab,cont_fecgen,cont_fecing,cont_fuente,cont_sinc,cont_codupload
FROM tbu_contacto
LOOP
RETURN NEXT rec ;
END LOOP;
RETURN ;
END;
' LANGUAGE plpgsql;

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2005-02-09 23:05:39 Re: libpq API incompatibility between 7.4 and 8.0
Previous Message Gavin M. Roy 2005-02-09 19:41:19 Re: PHP/PDO Database Abstraction Layer

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2005-02-10 06:06:07 Re: Function .. AS..?
Previous Message Tom Lane 2005-02-09 20:51:01 Re: parsing a string with a hexadecimal notation