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

Re: PL/pgSQL Syntax Problem

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-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 

In response to

pgsql-sql by date

Next:From: Kovacs ZoltanDate: 2002-03-05 17:52:15
Subject: getting pid of backend
Previous:From: Ismail BouabdallahDate: 2002-03-05 14:44:36
Subject: ERROR: fmgr_info: function 56664: cache lookup failed

pgsql-interfaces by date

Next:From: Tom LaneDate: 2002-03-05 16:03:57
Subject: Re: Error passing parameter to functions
Previous:From: Jose Luis LGDate: 2002-03-05 09:33:50
Subject: Error passing parameter to functions

pgsql-general by date

Next:From: Tom LaneDate: 2002-03-05 15:53:09
Subject: Re: storing intermediate results in recursive plpgsql functions
Previous:From: Tom LaneDate: 2002-03-05 15:48:12
Subject: Re: pg_dumpall storing multiple copies of DB's?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group