Re: Unknown kind of return type specified for function

Tom,  your example showed me what my problem was.

I was doing a 'select * from function(1,2,3)' instead for just 'select
function(1,2,3)'

Some of the error messages returned are so cryptic it is scary...

Avi

On Sunday, Jun 15, 2003, at 00:05 America/Chicago, Tom Lane wrote:

> 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)