Re: Return Query
- From: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
- To: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>
- Cc: pgsql-es-ayuda(at)postgresql(dot)org
- Subject: Re: Return Query
- Date: Fri, 27 Jun 2008 22:42:03 -0500
- Message-id: <3073cc9b0806272042s54ae040fm9e55501ce7812fc5(at)mail(dot)gmail(dot)com>
On Fri, Jun 27, 2008 at 11:06 AM, Edwin Quijada
<listas_quijada(at)hotmail(dot)com> wrote:
>
> Consigo el sigte error:
> ERROR: a column definition list is required for functions returning "record"
>
create or replace function f1(out id_record integer, out alias text)
returns setof record as
$$
begin
return query select id_record,alias from uno_email_alias;
end;
$$ language plpgsql;
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
Home |
Main Index |
Thread Index