| From: | Ashley Clark <aclark(at)ghoti(dot)org> |
|---|---|
| To: | Hubert Palme <hubert(dot)palme(at)web(dot)de> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: PL/pgSQL Syntax Problem |
| Date: | 2002-03-05 15:49:28 |
| Message-ID: | 20020305094928.A30697@tyrr.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces pgsql-sql |
* Hubert Palme in "PL/pgSQL Syntax Problem" dated 2002/03/04 21:34 wrote:
> Hi,
Hi,
> FOR daten IN
> SELECT * INTO daten FROM telefon WHERE t_lfd_nr = lfd_nr
when using a for loop you don't need the into, eg.
FOR daten IN
SELECT * FROM telefon WHERE t_lfd_nr = lfd_nr
each row will be placed in daten.
--
alkyl arches
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-03-05 15:53:09 | Re: storing intermediate results in recursive plpgsql functions |
| Previous Message | Tom Lane | 2002-03-05 15:48:12 | Re: pg_dumpall storing multiple copies of DB's? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-03-05 16:03:57 | Re: Error passing parameter to functions |
| Previous Message | Jose Luis LG | 2002-03-05 09:33:50 | Error passing parameter to functions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kovacs Zoltan | 2002-03-05 17:52:15 | getting pid of backend |
| Previous Message | Ismail Bouabdallah | 2002-03-05 14:44:36 | ERROR: fmgr_info: function 56664: cache lookup failed |