I have a postgres function that returns a boolean, I want to use this
return in another function.
How do I do it?
Will the following code help me fetch it in a variable:
select lv_flag = drop_table_if_exists(''alarmconfig'',false);
drop_table_if_exists is the function which I want to call.
Any help is appreciated.
From: scott.marlowe [mailto:scott(dot)marlowe(at)ihs(dot)com]
Sent: Wednesday, February 18, 2004 4:17 AM
To: Sumita Biswas (sbiswas)
Cc: 'Stephan Szabo'; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Function
On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote:
> Thanks for the answer.
> I have one more issue. How do I test a function that I wrote? I was
> able to create a function called Proc_ConferenceSummary(). In SQL
> Server I used to run it through query analyzer by writing the
> following command: exec Proc_ConferenceSummary
> But I don't know how to do it in Postgresql.
In response to
- Re: Function at 2004-02-21 08:12:22 from V i s h a l Kashyap @ [Sai Hertz And Control Systems]
pgsql-sql by date
|Next:||From: Fabian||Date: 2004-02-20 09:56:05|
|Subject: transaction block causing trouble|
|Previous:||From: daq||Date: 2004-02-20 07:44:49|
|Subject: Re: [SQL] Row counts/data changes. Any catalog table that has this info?|