Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group