| PostgreSQL 8.0.0 いゅゅン锣亩 PostgreSQL い瓣 籹虏砰いゅセ | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 9. ㄧ计㎝巨才 | Fast Forward | Next |
セ竊磞瓃êㄇ︽ㄧ计ヘ玡硂摸ㄧ计Τ腹ネΘㄧ计 Table 9-38 ┮瓃
Table 9-38. 腹ネΘㄧ计
| ㄧ计 | 把计摸 | 摸 | 磞瓃 |
|---|---|---|---|
| generate_series(start, stop) | int ┪ bigint | setof int ┪ setof bigint 籔把计摸 | ネΘ计眖 start stop˙秈 |
| generate_series(start, stop, step) | int or bigint | setof int or setof bigint (same as argument type) | ネΘ计眖 start stop˙秈 step |
狦 step 琌タ计τ start stop ê或箂︽稱猭狦 step 琌璽计start stop 玥箂︽狦琌 NULL 块玻ネ箂︽step 箂玥琌岿粇 琌ㄇㄒ
select * from generate_series(2,4);
generate_series
-----------------
2
3
4
(3 rows)
select * from generate_series(5,1,-2);
generate_series
-----------------
5
3
1
(3 rows)
select * from generate_series(4,3);
generate_series
-----------------
(0 rows)
select current_date + s.a as dates from generate_series(0,14,7) as s(a);
dates
------------
2004-02-05
2004-02-12
2004-02-19
(3 rows)