Re: Unknown kind of return type specified for function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Avi Schwartz <avi(at)CFFtechnologies(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unknown kind of return type specified for function
Date: 2003-06-15 05:05:44
Message-ID: 10908.1055653544@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Avi Schwartz <avi(at)CFFtechnologies(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Avi Schwartz 2003-06-15 06:45:21 Re: Unknown kind of return type specified for function
Previous Message Tom Lane 2003-06-15 04:42:38 Re: crypt vs password in pg_hba.conf