diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-01-02 15:08:08 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-01-02 15:15:21 +0200 |
| commit | 39b88432968a2f4c01c20948f12bf9c8e388474d (patch) | |
| tree | c79c81d964ef5a1caf6783ebda8ecfbf345d8006 /doc/src | |
| parent | e657b55e661577cf664949bce78068e2922f594f (diff) | |
| download | postgresql-39b88432968a2f4c01c20948f12bf9c8e388474d.tar.gz postgresql-39b88432968a2f4c01c20948f12bf9c8e388474d.zip | |
Implement remaining fields of information_schema.sequences view
Add new function pg_sequence_parameters that returns a sequence's start,
minimum, maximum, increment, and cycle values, and use that in the view.
(bug #5662; design suggestion by Tom Lane)
Also slightly adjust the view's column order and permissions after review of
SQL standard.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/information_schema.sgml | 27 |
1 files changed, 19 insertions, 8 deletions
diff --git a/doc/src/sgml/information_schema.sgml b/doc/src/sgml/information_schema.sgml index 962b85b8e4b..5861595c292 100644 --- a/doc/src/sgml/information_schema.sgml +++ b/doc/src/sgml/information_schema.sgml @@ -4139,31 +4139,42 @@ ORDER BY c.ordinal_position; </row> <row> - <entry><literal>maximum_value</literal></entry> - <entry><type>cardinal_number</type></entry> - <entry>Not yet implemented</entry> + <entry><literal>start_value</literal></entry> + <entry><type>character_data</type></entry> + <entry>The start value of the sequence</entry> </row> <row> <entry><literal>minimum_value</literal></entry> - <entry><type>cardinal_number</type></entry> - <entry>Not yet implemented</entry> + <entry><type>character_data</type></entry> + <entry>The minimum value of the sequence</entry> + </row> + + <row> + <entry><literal>maximum_value</literal></entry> + <entry><type>character_data</type></entry> + <entry>The maximum value of the sequence</entry> </row> <row> <entry><literal>increment</literal></entry> - <entry><type>cardinal_number</type></entry> - <entry>Not yet implemented</entry> + <entry><type>character_data</type></entry> + <entry>The increment of the sequence</entry> </row> <row> <entry><literal>cycle_option</literal></entry> <entry><type>yes_or_no</type></entry> - <entry>Not yet implemented</entry> + <entry><literal>YES</literal> if the sequence cycles, else <literal>NO</literal></entry> </row> </tbody> </tgroup> </table> + + <para> + Note that in accordance with the SQL standard, the start, minimum, + maximum, and increment values are returned as character strings. + </para> </sect1> <sect1 id="infoschema-sql-features"> |