Re: BUG #6177: Size field type TEXT

Claudio Oliveira <claudiomsi@hotmail.com> wrote:

> I'm doing the test in PGAdmin.
>
> Must be a bug in PGAdmim.
>
> I'm sorry I have not tested in psql
>
> create table txt (val text);
> txt insert into values ​​(repeat ('x', 4500));
> char_length select (val) from txt;
> txt insert into values ​​(repeat ('x', 4685));
> char_length select (val) from txt;
>
> select *, length (val) val is null, (val ~ 'x') from txt;

Hmm.  Maybe you should try taking this to the pgadmin-support list.

Your script came out sort of mangled in email, and apparently has
funny characters in it because I couldn't copy/paste and modify -- I
had to retype.  But this runs fine in psql for me:  (Printing the
hundreds of x's omitted from the post, but that looks OK to me,
too.)

test=# create table txt (val text);
CREATE TABLE
test=# insert into txt values (repeat('x', 4500));
INSERT 0 1
test=# insert into txt values (repeat('x', 4685));
INSERT 0 1
test=# select char_length(val), val is null, (val ~ 'x') from txt;
 char_length | ?column? | ?column?
-------------+----------+----------
        4500 | f        | t
        4685 | f        | t
(2 rows)

-Kevin