Re: calling user defined function with parameters..

What version are you using and what error are you getting? Your example
works for me on 7.2devel once i made a dpts table with an id_dpt column.

The function code is not checked for plpgsql until its first
use, so if there was a syntax error, it wouldn't be seen until you
tried to use it.

On Sat, 16 Jun 2001, Postgresql wrote:

> Hi,
>
> I've created a function like this :
>
> CREATE FUNCTION tester(INT4)
> RETURNS BOOL AS
> '
> DECLARE
> r RECORD;
> p ALIAS FOR $1;
>
> BEGIN
> SELECT INTO r
> id_dpt
> FROM dpts
> WHERE id_dpt=p;
>
> IF NOT FOUND THEN
> RETURN FALSE;
> ELSE
>
> RETURN TRUE;
> END IF;
> END;
> '
> LANGUAGE 'plpgsql';
>
> All is ok at creation.
> But now , how can i use my function ? i would like a thing like :
>
> SELECT tester(14) AS ok;
>
> But is make a Postgresql parser error
>
> How to do then ??
>
> Thanks for any help or links (other than the postgresql.org website...) !
>
> ;)
>
> Regards,
>
> Fred
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>