From: | Avi Schwartz <avi(at)CFFtechnologies(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unknown kind of return type specified for function |
Date: | 2003-06-15 06:45:21 |
Message-ID: | EF91F1B8-9EFC-11D7-BD41-000393AE5044@CFFtechnologies.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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)
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-06-15 10:33:28 | Re: full featured alter table? |
Previous Message | Tom Lane | 2003-06-15 05:05:44 | Re: Unknown kind of return type specified for function |