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(dot)mathur(at)airtightnetworks(dot)net]
Sent: Wednesday, August 10, 2005 8:00 PM
To: 'pgsql-sql(at)postgresql(dot)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