From: Akshay Mathur <akshay.mathur@airtightnetworks.net>
To: pgsql-sql@postgresql.org
Subject: sql function: using set as argument
Date: Wed, 10 Aug 2005 20:00:24 +0530
Message-ID: <001a01c59db8$0fdef360$6e01a8c0@pune.wibhu.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: akshay.mathur@airtightnetworks.net
Subject: Re: sql function: using set as argument
In-Reply-To: <001a01c59db8$0fdef360$6e01a8c0@pune.wibhu.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox