Hello ! Very good, thanks !
I've just not understood, when I have to write a function to test sql code and when I can do it interactively. Your shown function compiles and works, but I do not have the result in the logs [altough I see th executing function with my settings to 'debug' ;-) ]. Will just configure the logging tomorrow, that way, that the stronger ones are going to the syslog. br++mabra -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Scott Ribe Sent: Thursday, December 02, 2010 11:22 PM To: [email protected]@manfbraun.de Cc: [email protected] Subject: Re: [GENERAL] Looking for auto starting procedures On Dec 2, 2010, at 1:27 PM, <[email protected]> <[email protected]> wrote: > > I have not understand, where I can issue direct sql statements > and it looks like, the RAISE is not possible with plSql: Right, it's not actually SQL, so you can't use it in plain SQL. It is part of the plpgsql procedural language. So you could easily create a small stored procedure, for example: create function myraise(msg varchar, id varchar) returns void as $$ begin raise notice '%: %', msg, id; end; $$ language plpgsql; and call that from SQL: select myraise ('mymsg', '1234'); -- Scott Ribe [email protected] http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
