Обсуждение: Define function with no return value?

Поиск
Список
Период
Сортировка

Define function with no return value?

От
"Haron, Charles"
Дата:
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?

От
Tom Lane
Дата:
"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