Hi,
Can you tell me trim() spec, please ? (This problem has been
discussed in pgsql-jp ML. )
In trim(trailing 'abc' from '123cbabc') function, 'abc' means
~'[abc]'.
pgbash> select trim(trailing 'abc' from '123cbabc');
rtrim
----- 123 <==== it is not "123cb"!!
(1 row)
In current trim() function, MULTIBYTE string is broken.
pgbash> select trim(trailing '0x8842' from '0xB1428842'); --~~ ~~--~~
rtrim
-----0xB1 <==== MULTIBYTE string broken (This is a bug.)
(1 row)
If trim(trailing 'abc' from '123cbabc') returns "123cb", current
trim() spec is broken. However, the spec that 'abc' means ~'[abc]'
is ugly. It seems that this ugly spec isn't used for any kind of
functions argument and SQL expression except for trim().
How do you think about the trim() spec ?
--
Regards,
SAKAIDA Masaaki -- Osaka, Japan