Re: [HACKERS] UdmSearch: tables vs indices ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: Vince Vielhaber <vev(at)michvhf(dot)com>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] UdmSearch: tables vs indices ...
Date: 2000-01-06 15:52:32
Message-ID: 21273.947173952@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The Hermit Hacker <scrappy(at)hub(dot)org> writes:
> explain to me what *this* would do:

> sum(case dict.word when '$t' then 1 else 0 end)

Looks to me like it generates the same result as

select count(*) where dict.word = '$t';

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-01-06 15:57:52 New Search Engine ... UdmSearch
Previous Message Tom Lane 2000-01-06 15:50:27 Re: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL