Re: BUG #6177: Size field type TEXT
От | Kevin Grittner |
---|---|
Тема | Re: BUG #6177: Size field type TEXT |
Дата | |
Msg-id | 4E56665602000025000406E1@gw.wicourts.gov обсуждение исходный текст |
Ответ на | Re: BUG #6177: Size field type TEXT (Claudio Oliveira <claudiomsi@hotmail.com>) |
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: