Re: \0 and IllegalArgumentException

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)