Re: Error when trying to use a FOR loop - Mailing list pgsql-sql

am  21.07.2006, um  9:26:21 -0600 mailte Kevin Nikiforuk folgendes:
> Many thanks to Stephan, Richard and George.  When I was reading the documentation about FOR loops, I didn't realize
thatI was in the plpgsql section!
 
>  
> CREATE OR REPLACE FUNCTION rgio() RETURNS integer as $$
> BEGIN
>         DECLARE lv RECORD;

lv is a record...

>         FOR lv IN SELECT DISTINCT rg FROM ldevrg LOOP

untested: tv.rg


HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===