Re: [HACKERS] invalidly encoded strings

2007-09-11 Thread db
Try the sequence below. Then, try to dump and then reload the database. When you try to reload it, you will get an error: ERROR: invalid byte sequence for encoding UTF8: 0xbd I know this could be a problem (like chr() with invalid byte pattern). And that's enough of a problem already. We

Re: [HACKERS] invalidly encoded strings

2007-09-10 Thread db
I think the concern is when they use only one slash, like: E'\377\000\377'::bytea which, as I mentioned before, is not correct anyway. Wait, why would this be wrong? How would you enter the three byte bytea of consisting of those three bytes described above? Either as E'\\377\\000\\377'

Re: [HACKERS] like/ilike improvements

2007-05-23 Thread db
And Dennis said: It is only when you have a pattern like '%_' when this is a problem and we could detect this and do byte by byte when it's not. Now we check (*p == '\\') || (*p == '_') in each iteration when we scan over characters for '%', and we could do it once and have different loops

Re: [HACKERS] Money type todos?

2007-03-21 Thread db
Dennis Bjorklund [EMAIL PROTECTED] writes: What is the reason to keep it? The words-of-one-syllable answer is that D'Arcy Cain is still willing to put work into supporting the money type, and if it still gets the job done for him then it probably gets the job done for some other people