Re: [SQL] percentages of a column

"Andreas" <[EMAIL PROTECTED]> writes: > Example: > > Fruit Count % > -- > Bananas 5 10% > Apples 15 30% > Oranges 30 60% select fruit_name, count(*), round(count(*)::numeric / (select count(*) from basket) *

[SQL] percentages of a column

Hi, There is a Select that calculates some SUMs of objects. I'd like to show a list of counts and percentages of this counts based on the sum of all counts. Is that possible in a SELECT statement? Example: Fruit Count % -- Bananas 5 10%

Re: [SQL] Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?

On Thu, 28 Jun 2007, Andreas Joseph Krogh wrote: Anybody knows if queries of type "LIKE '%234%'" ever will be able to use indexes, and if someone is working on it? I'm sure I'm not the only one who would very much appreciate it:-) This is quite easily could be done with tsearch using substrin