Re: wrapping in extended mode doesn't work well with default pager - Mailing list pgsql-hackers

From Greg Stark
Subject Re: wrapping in extended mode doesn't work well with default pager
Date
Msg-id CAM-w4HOWVS0y8H=CRXn_Snv-V7J=zVvS1h7XkiaHz1F-wEC6-g@mail.gmail.com
Whole thread Raw
In response to Re: wrapping in extended mode doesn't work well with default pager  (Greg Stark <stark@mit.edu>)
Responses Re: wrapping in extended mode doesn't work well with default pager  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, May 12, 2014 at 2:12 PM, Greg Stark <stark@mit.edu> wrote:
> Hm, there was an off by one error earlier in some cases, maybe we
> fixed it by breaking other case. Will investigate.

Those spaces are coming from the ascii wrapping indicators. i.e. the periods in:

+-----------------+--------------------+
|        a       +|         a         +|
|                +|         b          |
|        b        |                    |
+-----------------+--------------------+
| xx              | yyyyyyyyyyyyyyyyyy |
| xxxx           +| yyyyyyyyyyyyyyyy  +|
| xxxxxx         +| yyyyyyyyyyyyyy    +|
| xxxxxxxx       +| yyyyyyyyyyyy      +|
| xxxxxxxxxx     +| yyyyyyyyyy        +|
| xxxxxxxxxxxx   +| yyyyyyyy          +|
| xxxxxxxxxxxxxx +| yyyyyy            +|
| xxxxxxxxxxxxxxx.| yyyy              +|
|.x              +| yy                +|
| xxxxxxxxxxxxxxx.|                    |
|.xxx            +|                    |
| xxxxxxxxxxxxxxx.|                    |
|.xxxxx           |                    |
+-----------------+--------------------+

Apparently we used to print those with border=1 in normal mode but in
expanded mode we left out the space for those on the outermost edges
since there was no need for them. If we put them in for wrapped mode
then we'll be inconsistent if we don't for nonwrapped mode though. And
if we don't put them in for wrapped mode then there's no way to
indicate wrapping versus newlines.

The biggest difference it makes is that in the border=1 mode the lines
ended at the end of the data previously. Now it's expanded to fill the
rectangle because of the plus symbols. ie. It used to look like:

-[ RECORD 1 ]-----------
a | xx |
b |
a | yyyyyyyyyyyyyyyyyy
b |
-[ RECORD 2 ]-----------
a | xxxx | xxxxxx
b | xxxxxxxx | xxxxxxxxxx | xxxxxxxxxxxx | xxxxxxxxxxxxxx | xxxxxxxxxxxxxxxx | xxxxxxxxxxxxxxxxxx |
xxxxxxxxxxxxxxxxxxxx
a | yyyyyyyyyyyyyyyy
b | yyyyyyyyyyyyyy | yyyyyyyyyyyy | yyyyyyyyyy | yyyyyyyy | yyyyyy | yyyy | yy |

and now looks like:

-[ RECORD 1 ]-----------a+| xx +|b |a+| yyyyyyyyyyyyyyyyyyb |
-[ RECORD 2 ]-----------a+| xxxx                + +| xxxxxx              +b | xxxxxxxx            +  | xxxxxxxxxx
  +  | xxxxxxxxxxxx        +  | xxxxxxxxxxxxxx      +  | xxxxxxxxxxxxxxxx    +  | xxxxxxxxxxxxxxxxxx  +  |
xxxxxxxxxxxxxxxxxxxxa+|yyyyyyyyyyyyyyyy    +b | yyyyyyyyyyyyyy      +  | yyyyyyyyyyyy        +  | yyyyyyyyyy          +
| yyyyyyyy            +  | yyyyyy              +  | yyyy                +  | yy                  +  |
 



-- 
greg



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: pgaudit - an auditing extension for PostgreSQL
Next
From: Andrew Dunstan
Date:
Subject: Re: cannot to compile PL/V8 on Fedora 20