diff options
| author | Fujii Masao <fujii@postgresql.org> | 2014-11-11 21:44:46 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2014-11-11 21:44:46 +0900 |
| commit | 1871c892021055532344266d7429b63f76a892c2 (patch) | |
| tree | 398b1e6ba2740383da88257bc2531d81ec33fe46 /doc/src | |
| parent | a1b395b6a26ae80cde17fdfd2def8d351872f399 (diff) | |
Add generate_series(numeric, numeric).
Платон Малюгин
Reviewed by Michael Paquier, Ali Akbar and Marti Raudsepp
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 16 |
1 files changed, 12 insertions, 4 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 7e5bcd98ddc..b58cfa578d5 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -14076,8 +14076,8 @@ AND <tbody> <row> <entry><literal><function>generate_series(<parameter>start</parameter>, <parameter>stop</parameter>)</function></literal></entry> - <entry><type>int</type> or <type>bigint</type></entry> - <entry><type>setof int</type> or <type>setof bigint</type> (same as argument type)</entry> + <entry><type>int</type>, <type>bigint</type> or <type>numeric</type></entry> + <entry><type>setof int</type>, <type>setof bigint</type>, or <type>setof numeric</type> (same as argument type)</entry> <entry> Generate a series of values, from <parameter>start</parameter> to <parameter>stop</parameter> with a step size of one @@ -14086,8 +14086,8 @@ AND <row> <entry><literal><function>generate_series(<parameter>start</parameter>, <parameter>stop</parameter>, <parameter>step</parameter>)</function></literal></entry> - <entry><type>int</type> or <type>bigint</type></entry> - <entry><type>setof int</type> or <type>setof bigint</type> (same as argument type)</entry> + <entry><type>int</type>, <type>bigint</type> or <type>numeric</type></entry> + <entry><type>setof int</type>, <type>setof bigint</type> or <type>setof numeric</type> (same as argument type)</entry> <entry> Generate a series of values, from <parameter>start</parameter> to <parameter>stop</parameter> with a step size of <parameter>step</parameter> @@ -14137,6 +14137,14 @@ SELECT * FROM generate_series(4,3); ----------------- (0 rows) +SELECT generate_series(1.1, 4, 1.3); + generate_series +----------------- + 1.1 + 2.4 + 3.7 +(3 rows) + -- this example relies on the date-plus-integer operator SELECT current_date + s.a AS dates FROM generate_series(0,14,7) AS s(a); dates |