plpgsql raise - parameters can be expressions - Mailing list pgsql-patches

Hello,

    I did trivial patch which eliminate limit raise command. Using
expressions instead of variables are a little bit expensive, but little.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

pokus=# create or replace function x() returns void as $$
declare c integer[] = '{10,20,30}'; a integer = 3;b record;
begin b := row(1,2);
  raise notice 'sss % % % % % % % % %', interval '23 hour',
    1, current_user, c,now(), c[1],
    (select * from fx where 1 = 0 limit 1),
    null,current_timestamp::timestamp(0);
end; $$ language plpgsql;
CREATE FUNCTION
pokus=# select x();
NOTICE:  sss 23:00:00 1 root {10,20,30} 2005-06-13 07:06:07.43569+02 10
<NULL> <NULL> 2005-06-13 07:
06:07

Regards
Pavel Stehule


Attachment

pgsql-patches by date:

Previous
From: Neil Conway
Date:
Subject: pl/pgsql dump tree cleanup
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: plpgsql raise - parameters can be expressions