Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] UdmSearch: tables vs indices ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] UdmSearch: tables vs indices ...
Date
Msg-id 21273.947173952@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] UdmSearch: tables vs indices ...  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
Tree view 
The Hermit Hacker <scrappy@hub.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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Enhancing PGSQL to be compatible with Informix SQL
Next
From: The Hermit Hacker
Date:
Subject: New Search Engine ... UdmSearch