2023年5月29日(月) 12:39 Wen Yi <896634...@qq.com>:
>
> Hi team,
> when I study the generate_series function, I found that it can not only
> generate the number series but also can generate the date series.(ref:
> https://www.postgresql.org/docs/current/functions-srf.html)
> That means I can make the
Hi team,
when I study the generate_series function, I found that it can not only
generate the number series but also can generate the date series.(ref:
https://www.postgresql.org/docs/current/functions-srf.html)
That means I can make the generate_series to generate the letter series.
So I try
Oh, I change my terminal settings (gnome-terminal), it works, thanks very much!
Yours,
Wen Yi
BeginnerC
896634...@qq.com
"=?gb18030?B?zsTSuw==?=" <896634...@qq.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
On Sunday, May 28, 2023, 文一 <896634...@qq.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
>
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
