Re: sql function: using set as argument - Mailing list pgsql-sql

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

-----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. (www.airtightnetworks.net)

O: +91 20 2588 1555 ext 205

F: +91 20 2588 1445