Re: A question about generate_series

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Sunday, May 28, 2023, 文一 <896634148@xxxxxx> wrote:

Hi team,

when I use the generate_series,as you can see

(Fedora Linux 37, PGSQL 15.3)

postgres=# SELECT x FROM generate_series(1, 25, 1) As x;
 x  
----
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
Time: 0.518 ms

My question is, why postgres didn't print the 22 to 25?

Can someone give some advice?

Thanks in advance!

Some kind of visual interaction between psql, the pager, and your terminal?

David J.