A question about generate_series

From: 文一 <896634148(at)qq(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: A question about generate_series
Date: 2023-05-29 01:24:39
Message-ID: tencent_1568D62DADC69896431AC591B85D4947BB0A@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;
&nbsp;x &nbsp;
----
&nbsp; 1
&nbsp; 2
&nbsp; 3
&nbsp; 4
&nbsp; 5
&nbsp; 6
&nbsp; 7
&nbsp; 8
&nbsp; 9
&nbsp;10
&nbsp;11
&nbsp;12
&nbsp;13
&nbsp;14
&nbsp;15
&nbsp;16
&nbsp;17
&nbsp;18
&nbsp;19
&nbsp;20
&nbsp;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!

Yours,
Wen Yi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-05-29 01:29:42 Re: A question about generate_series
Previous Message David G. Johnston 2023-05-27 03:20:31 Re: explicit-locking.html "key values" reference