Re: [GENERAL] function call

[Keow Yeong Huat Joseph]

Thank you.

Calling from java code, is the same as:

select test(1);

Regards
Joseph

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 9:22 AM
To: Keow Yeong Huat Joseph
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] function call


create or replace function test(integer) returns boolean as '
declare
  number alias for $1;
begin
  if number = 0 then 
     return false;
  else
     return true;
  end if;
end;' language 'plpgsql';

to call the function you can

SELECT test(1);

or can do

SELECT user_id,
       user_name,
       test(user_id) AS test
FROM users

or you can call from another function or from code.

Depending on where you wish to call the function / sp.

HTH
Darren



On Mon, 15 Sep 2003, Keow Yeong Huat Joseph wrote:

> Hi,
>  
> Would anyone able to advise how can I call a function/Stored procedure? what command 
> to issue?
>  
> Thanks.
>  
> 
> Best Regards
> 
> _______________________
> 
> Joseph Keow
> 
> 

-- 
Darren Ferguson


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match