| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Ernesto Quiñones A(dot) <ernesto(at)eqsoft(dot)net> |
| Cc: | pgsql-ayuda(at)tlali(dot)iztacala(dot)unam(dot)mx |
| Subject: | Re: [Pgsql-ayuda] Ayuda en un setof record |
| Date: | 2003-10-28 18:10:20 |
| Message-ID: | 20031028181020.GB3664@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
On Tue, Oct 28, 2003 at 01:14:14PM -0500, Ernesto Quiñones A. wrote:
> for r in EXECUTE ''select usu_codigo,dep_codigo from mae_usuarios'' loop
> return next r;
> end loop;
>
> select * from sp_lee_demandas('dd') as (usu_codigo text, dep_codigo text);
> WARNING: Error occurred while executing PL/pgSQL function sp_lee_demandas
> WARNING: line 5 at return next
> ERROR: Wrong record type supplied in RETURN NEXT
Y las columnas usu_codigo y dep_codigo de la tabla mae_usuarios son
efectivamente TEXT?
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La grandeza es una experiencia transitoria. Nunca es consistente.
Depende en gran parte de la imaginación humana creadora de mitos"
(Irulan)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ernesto Quiñones A. | 2003-10-28 18:14:14 | [Pgsql-ayuda] Ayuda en un setof record |
| Previous Message | Leonardo Boet Sánchez | 2003-10-28 15:55:41 | [Pgsql-ayuda] RE: [Pgsql-ayuda] PgAdmin III vamos para atrás ??? |