| From: | "Julio Cesar Rodriguez Dominguez" <jurasec(at)gmail(dot)com> |
|---|---|
| To: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
| Cc: | "Gabriel Ferro" <gabrielrferro(at)yahoo(dot)com(dot)ar>, pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Problema con execute |
| Date: | 2008-05-28 14:02:20 |
| Message-ID: | 925902880805280702p6edf201dtc9fede14b6b0d475@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
On Wed, May 28, 2008 at 12:28 AM, Jaime Casanova <systemguards(at)gmail(dot)com>
wrote:
> On Tue, May 27, 2008 at 10:01 PM, Julio Cesar Rodriguez Dominguez
> <jurasec(at)gmail(dot)com> wrote:
> >
> >> ERROR: missing FROM-clause entry for table "personas"
> >> LINEA 1: select analisis.personas.clave into claveper WHERE (document...
> >> ^
> >
> > El error esta claro, donde esta la clausula FROM?
> > y otra cosa, select into no esta soportado dentro de execute
> >
>
> puedes usar:
>
> EXECUTE 'select ...' INTO variable
>
> Gracias Jaime, por la aclaración.
>
> --
> Atentamente,
> Jaime Casanova
> Soporte y capacitación de PostgreSQL
> Guayaquil - Ecuador
> Cel. (593) 087171157
>
--
:: God bless you, every day and every night ::
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ing. Eris J. Gomez | 2008-05-28 14:02:52 | Instalacion desatendida |
| Previous Message | Alejandro D. Burne | 2008-05-28 13:52:16 | Re: Capturar transacciones durante un día |