Skip site navigation (1) Skip section navigation (2)

Re: BUG #6177: Size field type TEXT

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Claudio Oliveira" <claudiomsi(at)hotmail(dot)com>,<bruce(at)momjian(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6177: Size field type TEXT
Date: 2011-08-25 20:12:22
Message-ID: 4E56665602000025000406E1@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugs
Claudio Oliveira <claudiomsi(at)hotmail(dot)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

In response to

pgsql-bugs by date

Next:From: KenDate: 2011-08-26 08:31:17
Subject: BUG #6179: "service postgresql-9.0 stop" does not stop postgresql server
Previous:From: Noah HamersloughDate: 2011-08-25 19:05:34
Subject: BUG #6178: date_trunc : interval units "week" not supported contradicts documentation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group