pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedunscribe
2+ messages / 2 participants
[nested] [flat]
* unscribe
@ 2003-04-05 20:47 CIC mail <cguzman@cic.ipn.mx>
0 siblings, 0 replies; 2+ messages in thread
From: CIC mail @ 2003-04-05 20:47 UTC (permalink / raw)
To: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 2+ messages in thread
* UNSCRIBE
@ 2003-04-06 06:04 Hanan Harush <h_harush@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Hanan Harush @ 2003-04-06 06:04 UTC (permalink / raw)
To: pgsql-sql
UNSCRIBE
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-04-06 06:04 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-05 20:47 unscribe CIC mail <cguzman@cic.ipn.mx>
2003-04-06 06:04 UNSCRIBE Hanan Harush <h_harush@hotmail.com>
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