[SQL] sql function: using set as argument

[Akshay Mathur]

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. (www.airtightnetworks.net) O: +91 20 2588 1555 ext 205 F: +91 20 2588 1445