From: V i s h a l Kashyap @ [Sai Hertz And Control Systems] <sank89@sancharnet.in>
To: Sumita Biswas <sbiswas@cisco.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Function
Date: Sat, 21 Feb 2004 13:42:22 +0530
Message-ID: <403712E6.3030501@sancharnet.in> (raw)
In-Reply-To: <007e01c3f78d$ad346f50$2a154d0a@apac.cisco.com>
References: <007e01c3f78d$ad346f50$2a154d0a@apac.cisco.com>
Dear Sumita Biswas ,
>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.
>
>
If this valriable is
lv_flag and you are using plpgsql
just declase
lv_flag as boolean
and point as this
lv_flag := drop_table_if_exists(''alarmconfig'',false);
I hope this helps
--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap@jabber.org
ICQ : 264360076
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
I am usually called as Vishal Kashyap
and my Girlfriend calls me Vishal CASH UP.
Because everyone loves me as Vishal Kashyap
and my Girlfriend loves me as CASH.
___
//\\\
( 0_0 )
----------------o0o-----o0o---------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sank89@sancharnet.in, sbiswas@cisco.com
Subject: Re: Function
In-Reply-To: <403712E6.3030501@sancharnet.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox