X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 80B55D7793 for ; Tue, 30 Aug 2005 10:11:05 -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 54173-10 for ; Tue, 30 Aug 2005 13:10:59 +0000 (GMT) Received: from mailserv.pune.wibhu.com (unknown [210.212.168.94]) by svr1.postgresql.org (Postfix) with ESMTP id 9DFACD7BE4 for ; Tue, 30 Aug 2005 10:10:51 -0300 (ADT) Received: from Akshay ([192.168.1.151]) by mailserv.pune.wibhu.com (8.12.8/8.12.5) with ESMTP id j7UD6Ps0015324 for ; Tue, 30 Aug 2005 18:36:34 +0530 From: "Akshay Mathur" To: Subject: Re: sql function: using set as argument Date: Tue, 30 Aug 2005 18:41:14 +0530 Message-ID: <003b01c5ad64$502edaf0$9701a8c0@pune.wibhu.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003C_01C5AD92.69E716F0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 In-Reply-To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.19 required=5 tests=[AWL=0.000, HTML_90_100=0.189, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200509/51 X-Sequence-Number: 22598 This is a multi-part message in MIME format. ------=_NextPart_000_003C_01C5AD92.69E716F0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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: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 ------=_NextPart_000_003C_01C5AD92.69E716F0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Found a = solution

 

Second function can be written as =

        = ;    Get_count(anyarray, int)

        = ;            =             &= nbsp;   Select count(b_column) = from some_table where some_field_1 any ($1) and = some_field_2 =3D $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: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)

        = ;            =             &= nbsp;   Select count(b_column) from 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. (<= a href=3D"http://www.airtightnetworks.net/" target=3D"_new">www.airtightne= tworks.net)

O: +91 20 2588 1555 ext = 205

F: +91 20 2588 1445

 

------=_NextPart_000_003C_01C5AD92.69E716F0--