[BUGS] BUG #1813: lower() function doesn't work on unicode database

[yoursoft]

The following bug has been logged online:

Bug reference:  1813
Logged by:  yoursoft
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system:   SuSE 9.3 professional
Description:lower() function doesn't  work on unicode database
Details: 

We have a filesystem with latin2. The database created in unicode.
When we insert some Hungarian chars into it, and make a 'select kifejezes
from table' the result is fine.
When make 'select lower(kifejezes) from table', the result is wrong.
If any questions with the bug, please mail to [EMAIL PROTECTED]

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[BUGS] group by

[YourSoft]

Dear Developers,

There is a possible bug in 'select ... group by' SQL.
I reported it on the bugreport form on the web. (I think it number is 
2416?). But no any reaction to it.
It is not problem for me, I make my results in other way. But it is 
possible problem for other pepoples.


I reproduced it in smaller database table in other way. (with 18 
records) (postgresql 8.03 on linux)

e.g.:
there is a table:
stat-# \d summary
   Table "public.summary"
 colum   | Type  | MĂłdosĂ­tĂł
---++--
kifejezes | character varying(300) | not null
cnt   | integer| not null
talalat   | integer|
Indexes:
   "idx_summary_cnt" btree (cnt) CLUSTER
   "idx_summary_kifejezes" btree (kifejezes text_pattern_ops)

1)
select kifejezes, count(kifejezes) from summary group by kifejezes 
having count(kifejezes)>1;

the result is:
   kifejezes| count
-+---
csĂşcscsajok | 2
jĂĄszszentandrĂĄs | 3
kullancscsĂ­pĂŠs  | 2
magannyugdijpenztar | 2
magĂĄnnyugdijpĂŠnztĂĄr | 2
magĂĄnnyugdĂ­jpĂŠnztĂĄr | 3
magĂĄnnyugdĂ­jpĂŠnztĂĄrak   | 2
mĹąvelĹdĂŠsszociolĂłgia| 2
otp magĂĄnnyugdĂ­jpĂŠnztĂĄr | 2
(9 rows)

2)
select * from summary where kifejezes like 'jegygy%';
 kifejezes  | cnt | talalat
+-+-
jegygyĂźrĹą  |   4 |   0
jegygyĹąrĹą  |   5 |   0
jegygyĹąrĹą  |   7 |   0
jegygyĹąrĹą  |  12 |   0
jegygyĹąrĹąk |   3 |   0
(5 rows)


Why not is in the first query results the "jegygyĹąrĹą" (second query 
rows )?


---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [BUGS] group by

[YourSoft]

Dear Tom,

Thanks for suggestion. I upgrade my database to 8.1.3 and it is solve 
the problem :-)


Regards,
  Ferenc

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq