Re: [SQL] sql function: using set as argument

Akshay Mathur Mon, 05 Sep 2005 21:27:10 -0700

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

O: +91 20 2588 1555 ext 205

F: +91 20 2588 1445

-----Original Message-----
From: Akshay Mathur [mailto:[EMAIL PROTECTED]
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?