Re: Concat truncates at 257 characters - Mailing list pgsql-bugs

From Patrick Lademan
Subject Re: Concat truncates at 257 characters
Date
Msg-id CADMm_6D2L0Pdx6HbLiPuscgH8r_Pw2qFbYpoBh4Pyg5drr6VkA@mail.gmail.com
Whole thread Raw
In response to Re: Concat truncates at 257 characters  (John R Pierce <pierce@hogranch.com>)
Responses Re: Concat truncates at 257 characters  (John R Pierce <pierce@hogranch.com>)
Re: Concat truncates at 257 characters  (David Johnston <polobo@yahoo.com>)
List pgsql-bugs
What is difference between pgadmin and psql that would cause one to
truncate?
On Nov 25, 2013 6:18 PM, "John R Pierce" <pierce@hogranch.com> wrote:

> On 11/25/2013 3:09 PM, Patrick Lademan wrote:
>
>> The following simple examples all truncate at 257 characters and add a
>> trailing " (...)".
>>
>> select rpad('', 200, 'A') || rpad('', 200, 'B');
>>
>
> hmmm?
>
> $ psql scratch
> ....
> scratch=# select rpad('', 200, 'A') || rpad('', 200, 'B');
>
> ?column?
>
>
> ------------------------------------------------------------
> ------------------------------------------------------------------------
> ------------------------------------------------------------
> ------------------------------------------------------------------------
> ------------------------------------------------------------
> ------------------------------------------------------------------------
> ------
>  AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
> AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
> AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
> AAAAAAAAABBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
> BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
> BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
> BBBBB
> (1 row)
>
>
> not here.
>
> --
> john r pierce                                      37N 122W
> somewhere on the middle of the left coast
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

pgsql-bugs by date:

Previous
From: David Johnston
Date:
Subject: Re: Concat truncates at 257 characters
Next
From: John R Pierce
Date:
Subject: Re: Concat truncates at 257 characters