Tatsuo Ishii <[EMAIL PROTECTED]> writes:
>> If we make convert() operate on bytea and return bytea, as Tom
>> suggested, would that solve your use case?

> The problem is, the above use case is just one of what I can think of.

> Another use case is, something like this:

> SELECT sum(octet_length(convert(text_column using utf8_to_euc_jp))) FROM 
> mytable;

> to know the total byte length of text column if it's encoded in
> EUC_JP. 

Since octet_length exists and produces identical results for both text
and bytea, this example is hardly very convincing...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to