On Fri, 2004-10-29 at 10:24 -0400, Vadim Nasardinov wrote:
> | test=> select str, length(str) as length from dropme;
> | str | length
> | -------+--------
> | Hello | 5
> | (1 row)
> |
> | test=> select str, length(str) as length from dropme where str like '%world';
> | str | length
> | -------+--------
> | Hello | 5
> | (1 row)
> |
> | test=> select str, length(str) as length from dropme where str like '%Welt';
> | str | length
> | -----+--------
> | (0 rows)
> Not sure how the latest version behaves.
I get slightly different results from 7.4.5. The string is still
truncated, but the length is correct:
jorris=# select str, length(str) as length from dropme;
str | length
-------+--------
Hello | 11
(1 row)
jorris=# select str, length(str) as length from dropme where str like '%
world';
str | length
-------+--------
Hello | 11
(1 row)
jorris=# select substring(version(), 1, 20) as version;
version
----------------------
PostgreSQL 7.4.5 on
(1 row)