"lsliang" <lsli...@pconline.com.cn> writes: > http://www.postgresql.org/docs/9.0/interactive/typeconv-query.html > example shows:
> CREATE TABLE vv (v character(20)); > INSERT INTO vv SELECT 'abc' || 'def'; > SELECT v, length(v) FROM vv; > v | length > ----------------------+-------- > abcdef | 20 > (1 row) > but my test show not like this : Hmm, looks like that example was overlooked when we changed the behavior years ago: http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=f27976c85b1fb9002727cce65b9f9567e158f754 Given the context, we should change it to use octet_length(). Will fix, thanks. regards, tom lane -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
