Define function with no return value?

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

Define function with no return value?

От:
"Haron, Charles" <Charles.Haron@Cognitive.com>
Дата:
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 <tgl@sss.pgh.pa.us>
Дата:
"Haron, Charles"  writes:
> Is it posible to define a function with no return value?

In recent versions you can say RETURNS VOID.

			regards, tom lane
FAQ