Re: PL/pgSQL Syntax Problem - Mailing list pgsql-interfaces

From Ashley Clark
Subject Re: PL/pgSQL Syntax Problem
Date
Msg-id 20020305094928.A30697@tyrr.net
Whole thread Raw
In response to PL/pgSQL Syntax Problem  (Hubert Palme <hubert.palme@web.de>)
List pgsql-interfaces
* 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

pgsql-interfaces by date:

Previous
From: "Jose Luis LG"
Date:
Subject: Error passing parameter to functions
Next
From: Tom Lane
Date:
Subject: Re: Error passing parameter to functions