Re: Concat truncates at 257 characters

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
>