Re: How to Declare Functions Containing OUT PArameters?

On Wed, 2010-07-14 at 12:21 -0600, Bill Thoen wrote:
> I'm having some difficulty getting plpgsql to recognize a function with
> a couple of OUT parameters. I'm either declaring the function
> incorrectly, making the call to it in the wrong way or my program is
> simply possessed by evil spirits. I'm using Postgres 8.1.5.

First, 8.1.x is EOL as of November. You need to upgrade.


> CREATE OR REPLACE FUNCTION main() RETURNS VOID AS $$
> DECLARE
>    str1 text;
>    str2 text;
>    num integer := 0;
>    fnum real := 0.0;
> BEGIN
>    str1 := 'One fish, two fish';
>    str2 := 'Shark fish, No fish';
>    SELECT fishy( str1, str2, num, fnum) ;


> /*  ERROR MESSAGE
>
> psql:ex_out_fail.sql:28: ERROR:  function fishy(text, text, integer,
> real) does not exist
> HINT:  No function matches the given name and argument types. You may
> need to add explicit type casts.
> CONTEXT:  SQL statement "SELECT  fishy(  $1 ,  $2 ,  $3 ,  $4 )"
> PL/pgSQL function "main" line 9 at SQL statement
>

You are passing four IN paramaters. The out paramaters are used in
return are they not?

Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering