sql function: using set as argument

From: "Akshay Mathur" <akshay(dot)mathur(at)airtightnetworks(dot)net>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: sql function: using set as argument
Date: 2005-08-10 14:30:24
Message-ID: 001a01c59db8$0fdef360$6e01a8c0@pune.wibhu.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Owen Jacobson 2005-08-10 16:27:23 Re: **SPAM** Faster count(*)?
Previous Message Richard Huxton 2005-08-10 14:04:48 Re: Faster count(*)?