Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-23 Thread Martijn van Oosterhout
On Tue, Jul 22, 2008 at 04:32:39PM +0200, Zdenek Kotala wrote: > >Oh, so you're thinking of a charset as a sort of check constraint. If > >your locale is turkish and you have a column marked charset ASCII then > >storing lower('HI') results in an error. > > Yeah, if you use strcoll function it fai

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-22 Thread Zdenek Kotala
Martijn van Oosterhout napsal(a): On Mon, Jul 21, 2008 at 03:15:56AM +0200, Radek Strnad wrote: I was trying to sort out the problem with not creating new catalog for character sets and I came up following ideas. Correct me if my ideas are wrong. Since collation has to have a defined character

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-22 Thread Zdenek Kotala
Tom Lane napsal(a): Zdenek Kotala <[EMAIL PROTECTED]> writes: I think if we support UTF8 encoding, than it make sense to create own charsets, because system locales could have defined collation for that. Say what? I cannot imagine a scenario in which a user-defined encoding would be useful.

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-22 Thread Zdenek Kotala
Martijn van Oosterhout napsal(a): On Sat, Jul 12, 2008 at 10:02:24AM +0200, Zdenek Kotala wrote: Background: We specify encoding in initdb phase. ANSI specify repertoire, charset, encoding and collation. If I understand it correctly, then charset is subset of repertoire and specify list of all

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-21 Thread Martijn van Oosterhout
On Mon, Jul 21, 2008 at 03:15:56AM +0200, Radek Strnad wrote: > I was trying to sort out the problem with not creating new catalog for > character sets and I came up following ideas. Correct me if my ideas are > wrong. > > Since collation has to have a defined character set. Not really. AIUI at l

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-20 Thread Radek Strnad
I was trying to sort out the problem with not creating new catalog for character sets and I came up following ideas. Correct me if my ideas are wrong. Since collation has to have a defined character set I'm suggesting to use already written infrastructure of encodings and to use list of encodings

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-12 Thread Tom Lane
Zdenek Kotala <[EMAIL PROTECTED]> writes: > I think if we support UTF8 encoding, than it make sense to create own > charsets, > because system locales could have defined collation for that. Say what? I cannot imagine a scenario in which a user-defined encoding would be useful. The amount of inf

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-12 Thread Martijn van Oosterhout
On Sat, Jul 12, 2008 at 10:02:24AM +0200, Zdenek Kotala wrote: > Background: > We specify encoding in initdb phase. ANSI specify repertoire, charset, > encoding and collation. If I understand it correctly, then charset is > subset of repertoire and specify list of allowed characters for > langua

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-12 Thread Zdenek Kotala
Alvaro Herrera napsal(a): Zdenek Kotala escribió: The example is when you have translation data (vocabulary) in database. But the reason is that ANSI specify (chapter 4.2) charset as a part of string descriptor. See below: — The length or maximum length in characters of the character string

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-11 Thread Alvaro Herrera
Zdenek Kotala escribió: > The example is when you have translation data (vocabulary) in database. > But the reason is that ANSI specify (chapter 4.2) charset as a part of > string descriptor. See below: > > — The length or maximum length in characters of the character string type. > — The catal

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-11 Thread Zdenek Kotala
Martijn van Oosterhout napsal(a): On Thu, Jul 10, 2008 at 11:24:29PM +0200, Radek Strnad wrote: Hi, after long discussion with Mr. Kotala, we've decided to redesign our collation support proposal. For those of you who aren't familiar with my WIP patch and comments from other hackers here's the

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-11 Thread Martijn van Oosterhout
On Thu, Jul 10, 2008 at 11:24:29PM +0200, Radek Strnad wrote: > Hi, > > after long discussion with Mr. Kotala, we've decided to redesign our > collation support proposal. > For those of you who aren't familiar with my WIP patch and comments from > other hackers here's the original mail: > http://a

[HACKERS] [WIP] collation support revisited (phase 1)

2008-07-10 Thread Radek Strnad
Hi, after long discussion with Mr. Kotala, we've decided to redesign our collation support proposal. For those of you who aren't familiar with my WIP patch and comments from other hackers here's the original mail: http://archives.postgresql.org/pgsql-hackers/2008-07/msg00019.php In a few sentence