Re: [PERFORM] big distinct clause vs. group by

2011-04-25 Thread Uwe Bartels
Hi Vitalii, this sounds promising, can you send me that? Best Regards, Uwe 2011/4/25 Віталій Тимчишин > > > 2011/4/23 Robert Haas > >> On Apr 18, 2011, at 1:13 PM, Uwe Bartels wrote: >> > Hi Robert, >> > >> > thanks for your answer. >> > the aggregate function I was talking about is the fun

Re: [PERFORM] big distinct clause vs. group by

2011-04-25 Thread Віталій Тимчишин
2011/4/23 Robert Haas > On Apr 18, 2011, at 1:13 PM, Uwe Bartels wrote: > > Hi Robert, > > > > thanks for your answer. > > the aggregate function I was talking about is the function I need to use > for the non-group by columns like min() in my example. > > There are of course several function to

Re: [PERFORM] big distinct clause vs. group by

2011-04-24 Thread Uwe Bartels
On 23 April 2011 21:34, Robert Haas wrote: > On Apr 18, 2011, at 1:13 PM, Uwe Bartels wrote: > > Hi Robert, > > > > thanks for your answer. > > the aggregate function I was talking about is the function I need to use > for the non-group by columns like min() in my example. > > There are of cours

Re: [PERFORM] big distinct clause vs. group by

2011-04-23 Thread Robert Haas
On Apr 18, 2011, at 1:13 PM, Uwe Bartels wrote: > Hi Robert, > > thanks for your answer. > the aggregate function I was talking about is the function I need to use for > the non-group by columns like min() in my example. > There are of course several function to choose from, and I wanted to know

Re: [PERFORM] big distinct clause vs. group by

2011-04-19 Thread Claudio Freire
On Tue, Apr 19, 2011 at 11:07 AM, Robert Klemme wrote: > I find that slightly contradictory: either you do care about the > values then your business requirements dictate the aggregate function. >  If you only want to pick any value actually in the table but do not > care about which one (e.g. MIN

Re: [PERFORM] big distinct clause vs. group by

2011-04-19 Thread Robert Klemme
On Tue, Apr 19, 2011 at 10:47 AM, Uwe Bartels wrote: > Oh, I do care about these columns. > But by using an group by on the key columns, I cannot select the columns as > they are. Otherwise you get an error message. > So I have to use an aggregate functionlike min(). I find that slightly contradi

Re: [PERFORM] big distinct clause vs. group by

2011-04-19 Thread Uwe Bartels
Hi Robert, Oh, I do care about these columns. But by using an group by on the key columns, I cannot select the columns as they are. Otherwise you get an error message. So I have to use an aggregate functionlike min(). Best... Uwe On 19 April 2011 10:24, Robert Klemme wrote: > On Mon, Apr 18,

Re: [PERFORM] big distinct clause vs. group by

2011-04-19 Thread Robert Klemme
On Mon, Apr 18, 2011 at 7:13 PM, Uwe Bartels wrote: > the aggregate function I was talking about is the function I need to use for > the non-group by columns like min() in my example. > There are of course several function to choose from, and I wanted to know > which causes as less as possible res

Re: [PERFORM] big distinct clause vs. group by

2011-04-18 Thread Uwe Bartels
Hi Robert, thanks for your answer. the aggregate function I was talking about is the function I need to use for the non-group by columns like min() in my example. There are of course several function to choose from, and I wanted to know which causes as less as possible resources. best regards, Uw

Re: [PERFORM] big distinct clause vs. group by

2011-04-18 Thread Robert Haas
On Wed, Mar 16, 2011 at 4:45 AM, Uwe Bartels wrote: > I'm having trouble with some sql statements which use an expression with > many columns and distinct in the column list of the select. > select distinct col1,col2,.col20,col21 > from table1 left join table2 on ,... > where >  ; > > The nega