pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsql function: using set as argument
4+ messages / 2 participants
[nested] [flat]
* sql function: using set as argument
@ 2005-08-10 14:30 Akshay Mathur <akshay.mathur@airtightnetworks.net>
0 siblings, 1 reply; 4+ messages in thread
From: Akshay Mathur @ 2005-08-10 14:30 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: sql function: using set as argument
@ 2005-08-15 22:09 Thomas F. O'Connell <tfo@sitening.com>
parent: Akshay Mathur <akshay.mathur@airtightnetworks.net>
0 siblings, 1 reply; 4+ messages in thread
From: Thomas F. O'Connell @ 2005-08-15 22:09 UTC (permalink / raw)
To: Akshay Mathur <akshay.mathur@airtightnetworks.net>; +Cc: pgsql-sql
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 = $2;
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
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
> 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
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: sql function: using set as argument
@ 2005-08-16 05:53 Akshay Mathur <akshay.mathur@airtightnetworks.net>
parent: Thomas F. O'Connell <tfo@sitening.com>
0 siblings, 0 replies; 4+ messages in thread
From: Akshay Mathur @ 2005-08-16 05:53 UTC (permalink / raw)
To: 'Thomas F. O'Connell' <tfo@sitening.com>; +Cc: pgsql-sql
Thanks! Thomas
Actually I am going to use many functions for different counts and a
wrapper function to return all count in one shot. My function1 is going
to be a part of all count functions. If I use it as sub query in all the
functions, performance degrades drastically, as my query of finction1 is
also heavy.
My wrapper function is going to look like:
Get_all_counts()
Select count1(result_set_of_finction1, int,
int), count2(result_set_of_finction1, int, int),
count3(result_set_of_finction1, int, int)...
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
-----Original Message-----
From: Thomas F. O'Connell [mailto:tfo@sitening.com]
Sent: Tuesday, August 16, 2005 3:39 AM
To: Akshay Mathur
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] sql function: using set as argument
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 = $2;
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your iT
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 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: sql function: using set as argument
@ 2005-08-30 13:11 Akshay Mathur <akshay.mathur@airtightnetworks.net>
0 siblings, 0 replies; 4+ messages in thread
From: Akshay Mathur @ 2005-08-30 13:11 UTC (permalink / raw)
To: pgsql-sql
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. ( <http://www.airtightnetworks.net/;
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. ( <http://www.airtightnetworks.net/;
www.airtightnetworks.net)
O: +91 20 2588 1555 ext 205
F: +91 20 2588 1445
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-08-30 13:11 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-10 14:30 sql function: using set as argument Akshay Mathur <akshay.mathur@airtightnetworks.net>
2005-08-15 22:09 ` Thomas F. O'Connell <tfo@sitening.com>
2005-08-16 05:53 ` Akshay Mathur <akshay.mathur@airtightnetworks.net>
2005-08-30 13:11 Re: sql function: using set as argument Akshay Mathur <akshay.mathur@airtightnetworks.net>
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