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; |
- [SQL] Function .. AS..? Ing. Jhon Carrillo
- Re: [SQL] [HACKERS] Function .. AS..? Stephan Szabo
- Re: [SQL] Function .. AS..? Michael Fuhr