Re: [BUGS] incorrect collation order in at least some non-C locales

2006-02-05 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > This is probably not "broken collation order" but instead how those > locales are defined. I'd only consider it "broken" if you get different sort order from sort(1) under the same locale. Here is an example from Fedora 4 showing that sort(1) has the sa

Re: [BUGS] incorrect collation order in at least some non-C locales

2006-02-05 Thread Stephan Szabo
On Sun, 5 Feb 2006, Martin Pitt wrote: > Hi PostgreSQL developers! > > I recently got the email below and confirmed that I get the same > broken collation order in de_DE.UTF-8 as the original reporter (who > probably uses pt_PT.something). It works fine in C, though. This is probably not "broken

[BUGS] incorrect collation order in at least some non-C locales

2006-02-05 Thread Martin Pitt
Hi PostgreSQL developers! I recently got the email below and confirmed that I get the same broken collation order in de_DE.UTF-8 as the original reporter (who probably uses pt_PT.something). It works fine in C, though. System: Debian unstable, according to the reporter the bug does not happen und

Re: [BUGS] BUG #2236: extremely slow to get unescaped bytea data

2006-02-05 Thread Kalador Tech Support
This is a table with just one entry created to test the problem. Should not have any indexing issues. I've since isolated the problem to the unescape_bytea function not the SELECT. I inserted the same image to a bytea column using base64 encoding, and extracted it from the table (using base