From: CIC mail <cguzman@cic.ipn.mx>
To: pgsql-sql@postgresql.org
Subject: unscribe
Date: Sat, 5 Apr 2003 14:47:44 -0600
Message-ID: <001301c2fbb4$9d0b3e40$9264a8c0@cguzman> (raw)
References: <F122429B-64C3-11D7-AEDC-00306571D2C4@mars-hq.com>
UNSCRIBE
Atentamente
M. en C. César Saúl Guzmán Rentería
Jefe de la Unidad de Desarrollo de Aplicaciones
Subdirección de Investigación Aplicada
Centro de Investigación en Computación
Teléfono: 57-29-60-00, extensiones: 56551, 56587
----- Original Message -----
From: "Walter McGinnis" <walter@mars-hq.com>
To: <pgsql-sql@postgresql.org>
Sent: Tuesday, April 01, 2003 10:31 PM
Subject: [SQL] pesky plpgsql
> Guess I'm an April Fool. When I define the following psql returns
> "CREATE":
>
> -- update all galleries that are categories with their skey and rkey
> values
> CREATE FUNCTION update_cat_keys() RETURNS integer AS '
> declare
> v_row RECORD;
> begin
> for v_row in select gallery_id,
> imagedb_gallery_hierarchy_skey(gallery_id, NULL, '''') as skey,
> imagedb_gallery_hierarchy_rskey(gallery_id, NULL, '''') as rskey from
> imagedb_galleries where category_p = ''t'' loop
>
> update imagedb_galleries
> set skey = v_row.skey, rskey = v_row.rskey
> where gallery_id = v_row.gallery_id;
> end loop;
> return 1;
> end;
> ' LANGUAGE 'plpgsql';
>
> When I call the function I get the following error:
>
> devpps=# select update_cat_keys();
> NOTICE: plpgsql: ERROR during compile of update_cat_keys near line 2
> ERROR: parse error at or near ";"
>
> The select in the loop runs fine in psql. So I'm stumped...
>
> I'm pretty ignorant about plpgsql, I'm used to pl/sql.
>
> TIA,
>
> Walter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cguzman@cic.ipn.mx
Subject: Re: unscribe
In-Reply-To: <001301c2fbb4$9d0b3e40$9264a8c0@cguzman>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox