efficiency of group by 1 order by 1

From: TJ O'Donnell <tjo(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: efficiency of group by 1 order by 1
Date: 2006-03-17 14:35:35
Message-ID: 441AC937.5020105@acm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>> Is there a way to eliminate the ugly repeated use of
>> date_trunc('day',endtime)?

>>In this particular case you could say
>>
>> ... GROUP BY 1 ORDER BY 1;

I use a similar SQL, e.g.:
select func(x)....group by func(x) order by func(x)
but my func is rather expensive. Is func(x) evaluated three times
in the above statement? Would it be evaluated only once if I used
select func(x)....group by 1 order by 1

TJ O'Donnell
www.gnova.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-03-17 14:50:11 Re: Slow trigger on identical DB but different machine
Previous Message Emi Lu 2006-03-17 14:29:22 Re: About index for temporay table in a plpgsql function