Re: [SQL] [HELP] Defining a function as a procedure

2006-01-26 Thread Tom Lane
"Daniel Caune" <[EMAIL PROTECTED]> writes: > Is there a way to define a function as a procedure, I mean a function > that returns nothing. In recent versions you can say RETURNS VOID, which is a bit of a hack but it gets the point across... regards, tom lane -

[SQL] [HELP] Defining a function as a procedure

2006-01-26 Thread Daniel Caune
Hi,   Is there a way to define a function as a procedure, I mean a function that returns nothing.   CREATE OR REPLACE FUNCTION foo() AS $$ BEGIN   END; $$ LANGUAGE 'plpgsql';   Actually, PostgreSQL complains as a “function result type must be specified”.  I can patch my function