Re: Unknown kind of return type specified for function - Mailing list pgsql-general

From Tom Lane
Subject Re: Unknown kind of return type specified for function
Date
Msg-id 10908.1055653544@sss.pgh.pa.us
Whole thread Raw
In response to Unknown kind of return type specified for function  (Avi Schwartz <avi@CFFtechnologies.com>)
Responses Re: Unknown kind of return type specified for function
List pgsql-general
Avi Schwartz <avi@CFFtechnologies.com> writes:
> How do I declare the fact that the function will return nothing?

"returns void" works fine for me.

regression=# create or replace function splite_delete_configured_selection(int,
regression(# int, int, int)
regression-# returns void
regression-# as '
regression'# begin
regression'# return;
regression'# end;
regression'# ' language 'plpgsql';
CREATE FUNCTION
regression=# select splite_delete_configured_selection(1,2,3,4);
 splite_delete_configured_selection
------------------------------------

(1 row)


            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: crypt vs password in pg_hba.conf
Next
From: Avi Schwartz
Date:
Subject: Re: Unknown kind of return type specified for function