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

From Avi Schwartz
Subject Re: Unknown kind of return type specified for function
Date
Msg-id EF91F1B8-9EFC-11D7-BD41-000393AE5044@CFFtechnologies.com
Whole thread Raw
In response to Re: Unknown kind of return type specified for function  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unknown kind of return type specified for function
List pgsql-general
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)


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unknown kind of return type specified for function
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: full featured alter table?