Re: plpgsql raise - parameters can be expressions

> 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

I like :)

+1