From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | 文一 <896634148(at)qq(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: A question about generate_series |
Date: | 2023-05-29 01:30:25 |
Message-ID: | 94719.1685323825@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"=?gb18030?B?zsTSuw==?=" <896634148(at)qq(dot)com> writes:
> 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?
I'm betting there's something broken about your pager
settings, because 21 is as far as the display would get
in a standard-height (24 lines) xterm window. When I do
this I see
...
19
20
21
--More--
Since you're not getting a prompt but just the subsequent
\timing output, it seems that the rest of the output went
into the bit bucket, which psql would certainly never do
on its own. But a malfunctioning pager might act that way.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Wen Yi | 2023-05-29 01:32:46 | Re: A question about generate_series |
Previous Message | David G. Johnston | 2023-05-29 01:29:42 | Re: A question about generate_series |