Re: A question about generate_series

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: 文一 <896634148(at)qq(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: A question about generate_series
Date: 2023-05-29 01:29:42
Message-ID: CAKFQuwb+e36PTWvvwUH-zg9xXcuPdLu557HMbGt-2iMm--gySQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sunday, May 28, 2023, 文一 <896634148(at)qq(dot)com> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-05-29 01:30:25 Re: A question about generate_series
Previous Message 文一 2023-05-29 01:24:39 A question about generate_series