X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B750552970 for ; Mon, 15 Aug 2005 19:09:08 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43418-02 for ; Mon, 15 Aug 2005 22:09:05 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 9A12E528D2 for ; Mon, 15 Aug 2005 19:09:04 -0300 (ADT) Received: (qmail 30402 invoked from network); 15 Aug 2005 22:09:06 -0000 Received: from pcp0012204803pcs.blairblvd.tn.nash.comcast.net (HELO ?192.168.15.104?) (69.245.49.69) by 0 with SMTP; 15 Aug 2005 22:09:06 -0000 In-Reply-To: <001a01c59db8$0fdef360$6e01a8c0@pune.wibhu.com> References: <001a01c59db8$0fdef360$6e01a8c0@pune.wibhu.com> Mime-Version: 1.0 (Apple Message framework v733) X-Priority: 3 (Normal) Content-Type: multipart/alternative; boundary=Apple-Mail-6--192346934 Message-Id: Cc: From: "Thomas F. O'Connell" Subject: Re: sql function: using set as argument Date: Mon, 15 Aug 2005 17:09:01 -0500 To: Akshay Mathur X-Mailer: Apple Mail (2.733) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.133 required=5 tests=[AWL=-0.100, HTML_FONT_BIG=0.232, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200508/96 X-Sequence-Number: 22324 --Apple-Mail-6--192346934 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=WINDOWS-1252; delsp=yes; format=flowed Is there a reason not to build it in as a sub-query? E.g., if you have a function get_count( int ): SELECT count(b_column) FROM some_table WHERE some_field_1 in ( SELECT a_column FROM a_table WHERE some_condition ) AND some_field_2 =3D $2; -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i=99 http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-469-5150 615-469-5151 (fax) On Aug 10, 2005, at 9:30 AM, Akshay Mathur wrote: > 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 =20 > function > > Second looks like: > > Get_count(result_set_of_function_1, int) > > Select count(b_column) from =20 > some_table where some_field_1 in ($1) and some_field_2 =3D $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 > > --Apple-Mail-6--192346934 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=WINDOWS-1252
Is there a reason not to = build it in as a sub-query?

E.g., if you have a = function get_count( int ):

SELECT=A0count(b_column)
FROM some_table
WHERE some_field_1 in (
=A0=A0 =A0SELECT = a_column
=A0=A0 =A0FROM = a_table
=A0 =A0 = WHERE=A0some_condition
AND=A0some_field_2 =3D = $2;

http://www.sitening.com/
11= 0 30th Avenue North, Suite 6
Nashville, TN = 37203-6320
615-469-5150
615-469-5151 (fax)
=
On Aug 10, 2005, at 9:30 AM, Akshay Mathur = wrote:

Hi,

=A0

I have a function that = returns a set.

Looks = like:

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = Select a_column from a_table where = some_condition;

=A0<= /P>

I want to use output of = this function as an argument of another = function

=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0 Second looks like:

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 Get_count(result_set_of_function_1, = int)

=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0 =A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 Select count(b_column) from some_table where = some_field_1 in ($1) and some_field_2 =3D = $2;

=A0

Please suggest how can I = do that?

=A0

Regards,

=A0

akshay

=

=A0

=A0

------------------------------------= ---

Akshay = Mathur
SMTS, Product = Verification

AirTight = Networks, Inc. (<= FONT size=3D"1" color=3D"navy" face=3D"Arial">www.airtightnetworks.net)

=A0

=

= --Apple-Mail-6--192346934--