From: Akshay Mathur <akshay.mathur@airtightnetworks.net>
To: pgsql-sql@postgresql.org
Subject: Re: sql function: using set as argument
Date: Tue, 30 Aug 2005 18:41:14 +0530
Message-ID: <003b01c5ad64$502edaf0$9701a8c0@pune.wibhu.com> (raw)
Found a solution
Second function can be written as
Get_count(anyarray, int)
Select count(b_column) from
some_table where some_field_1 any ($1) and some_field_2 = $2;
Calling this function:
Select Get_count(array(function_1), int_value)
Regards,
akshay
---------------------------------------
Akshay Mathur
SMTS, Product Verification
AirTight Networks, Inc. ( <http://www.airtightnetworks.net/;
www.airtightnetworks.net)
O: +91 20 2588 1555 ext 205
F: +91 20 2588 1445
-----Original Message-----
From: Akshay Mathur [mailto:akshay.mathur@airtightnetworks.net]
Sent: Wednesday, August 10, 2005 8:00 PM
To: 'pgsql-sql@postgresql.org'
Subject: sql function: using set as argument
Hi,
I have a function that returns a set.
Looks like:
Select a_column from a_table where some_condition;
I want to use output of this function as an argument of another function
Second looks like:
Get_count(result_set_of_function_1, int)
Select count(b_column) from
some_table where some_field_1 in ($1) and some_field_2 = $2;
Please suggest how can I do that?
Regards,
akshay
---------------------------------------
Akshay Mathur
SMTS, Product Verification
AirTight Networks, Inc. ( <http://www.airtightnetworks.net/;
www.airtightnetworks.net)
O: +91 20 2588 1555 ext 205
F: +91 20 2588 1445
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: akshay.mathur@airtightnetworks.net
Subject: Re: sql function: using set as argument
In-Reply-To: <003b01c5ad64$502edaf0$9701a8c0@pune.wibhu.com>
* 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