Thread: Define function with no return value?

Define function with no return value?

From
"Haron, Charles"
Date:
Is it posible to define a function with no return value?

I've something like "CREATE FUNCTION set_to_active(int4) RETURNS NULL AS
..." but I get an parse error at or near "NULL"

Thanks,
Chuck

Re: Define function with no return value?

From
Tom Lane
Date:
"Haron, Charles" <Charles.Haron@Cognitive.com> writes:
> Is it posible to define a function with no return value?

In recent versions you can say RETURNS VOID.

            regards, tom lane