Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-19 Thread Andreas Peer
Tom Lane schrieb: > Andreas Peer <[EMAIL PROTECTED]> writes: > >> Well, the use case is a strange one... I would like to use a varchar() >> column for storing a variable-length vector of integers. The numbers are >> represented by the codepoints. Therefore, I need to sort them as binary >> da

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-18 Thread Tom Lane
Andreas Peer <[EMAIL PROTECTED]> writes: > Well, the use case is a strange one... I would like to use a varchar() > column for storing a variable-length vector of integers. The numbers are > represented by the codepoints. Therefore, I need to sort them as binary > data, not as characters. I woul

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-18 Thread Peter Eisentraut
Andreas Peer wrote: Well, the use case is a strange one... I would like to use a varchar() column for storing a variable-length vector of integers. The numbers are represented by the codepoints. Therefore, I need to sort them as binary data, not as characters. I would often need to get all the

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-18 Thread Andreas Peer
Tom Lane wrote: Heikki Linnakangas <[EMAIL PROTECTED]> writes: [EMAIL PROTECTED] wrote: The function convert_to(string text, dest_encoding name) is not allowed to be used in a index expression, because it is not marked as "IMMUTABLE". You can change the way a conversion is d

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-17 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: >> The function convert_to(string text, dest_encoding name) is not allowed to >> be used in a index expression, because it is not marked as "IMMUTABLE". > You can change the way a conversion is done with CREATE/DROP CONVERSI

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-17 Thread Heikki Linnakangas
[EMAIL PROTECTED] wrote: PostgreSQL version: 8.3.3 Operating system: Linux Description:convert_to() should be immutable Details: The function convert_to(string text, dest_encoding name) is not allowed to be used in a index expression, because it is not marked as "IMMUTABLE". Accordin

[BUGS] BUG #4421: convert_to() should be immutable

2008-09-17 Thread
The following bug has been logged online: Bug reference: 4421 Logged by: Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Linux Description:convert_to() should be immutable Details: The function convert_to(string text, dest_encoding name