It looks blank, but its contents are actually there. ctrl-a, ctrl-c in the column selects what you''d expect to see.<br
/>Thebehavior happens a 65536 in the lpad<br /><br />select lpad('test', 65535, 't') -- looks OK<br /> select
lpad('test',65536, 't') -- looks empty (but really isn't)<br /><br /><br /><br /><div class="gmail_quote">On Tue,
Jul27, 2010 at 12:08 PM, Peter Geoghegan <span dir="ltr"><<a
href="mailto:peter.geoghegan86@gmail.com">peter.geoghegan86@gmail.com</a>></span>wrote:<br /><blockquote
class="gmail_quote"style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left:
1ex;">Here'sJeff's test case. I am not immediately able to check it:<br /><br /> On 27 July 2010 17:54, Jeff Adams
<<ahref="mailto:jadams@azavea.com">jadams@azavea.com</a>> wrote:<br /> > Piece o' cake:<br /> ><br /> >
selectlpad('test', 75, 't') as test75, lpad('test', 750, 't') as test750,<br /> > lpad('test', 7500, 't') as
test7500,lpad('test', 75000, 't') as test75000,<br /> > lpad('test', 10000, 't') as test10000<br /> ><br /> >
Forme, I see "tttttttttttttttttttttt" in the (non-resized) test75, test750,<br /> > test7500, and test10000 columns,
butthe test75000 column has a blank cell.<br /> ><br /> > Jeff<br /> ><br /> ><br /><br /><br /> --<br />
Regards,<br/> Peter Geoghegan<br /><font color="#888888"><br /> --<br /> Sent via pgadmin-support mailing list (<a
href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br/> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></font></blockquote></div><br />