Re: [SQL] Slow sub-selects, max and count(*)

2004-03-27 Thread Greg Stark
Josh Berkus <[EMAIL PROTECTED]> writes: > Max() and Count() cannot use indexes for technical reasons. Browse through > the archives of SQL, PERFORM, and HACKERS for about 12,000 discussions on the > subject. Please don't confuse the issue by throwing Max() and Count() into the same basket.

Re: [SQL] Invalid Unicode Character Sequence found

2004-03-27 Thread Markus Bertheau
Ð ÐÑÐ, 26.03.2004, Ð 22:43, Tom Lane ÐÐÑÐÑ: > "Bulatovic Natasa" <[EMAIL PROTECTED]> writes: > > select id, title from docs where title like 'z%'; or > > select id, title from docs where title like 'Z%'; > > It reports the following error: > > ERROR: Invalid UNICODE character sequence found (0xc0