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: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Scott Ribe Sent: Thursday, December 02, 2010 11:22 PM To: mabra@xxxxxxxxxxxxxxxxx@manfbraun.de Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Looking for auto starting procedures On Dec 2, 2010, at 1:27 PM, <mabra@xxxxxxxxxxxx> <mabra@xxxxxxxxxxxx> 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 scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ (303) 722-0567 voice -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
