Thread: calling user defined function with parameters..

Hi,

I've created a function like this :

CREATE FUNCTION tester(INT4)
RETURNS BOOL AS
'
DECLAREr RECORD;p ALIAS FOR $1;

BEGINSELECT INTO r id_dptFROM dptsWHERE 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

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@postgresql.org
>