Re: RAISE <level> <expr> <params>: state of play and request

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: RAISE <level> <expr> <params>: state of play and request
Date: 2001-09-05 21:24:43
Message-ID: 200109052124.f85LOh508099@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers


Was this completed?

> OK, so I've defined a grammar for string_expr, which means the following
> currently works:
>
> CREATE FUNCTION foo_raise_loop(text) RETURNS text AS '
> DECLARE
> a ALIAS FOR $1;
> i integer;
> myrec RECORD;
> BEGIN
> i:=0;
> FOR myrec IN SELECT * FROM colours LOOP
> i:=i+1;
> RAISE NOTICE a || '' : '' || '' colour % is '' || myrec.c_name ||
> ''.'', i, myrec.c_id;
> END LOOP;
> RETURN ''done''::text;
> END;' LANGUAGE 'plpgsql';
>
> SELECT foo_raise_loop('Looping (%)');
>
>
> Which produces (note the % nr Looping gets evaluated):
>
> NOTICE: Looping (1) : colour 1 is red.
> NOTICE: Looping (2) : colour 2 is green.
> NOTICE: Looping (3) : colour 3 is blue.
>
>
> What you haven't got are: brackets, casts, function calls, other operators
> (can't do i+1).
>
> I'm going to be out of town for a few days then busy for a couple of weeks.
> Throw in a week to debug,document and apply against CVS and we're into
> August. So - do you want it with current functionality or should I press on?
>
> - Richard Huxton
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-09-06 00:03:26 Re: Performance TODO items
Previous Message Joe Conway 2001-09-05 20:34:06 Bytea string operator support