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 /src/include/commands/sequence.h | |
| 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 'src/include/commands/sequence.h')
| -rw-r--r-- | src/include/commands/sequence.h | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/include/commands/sequence.h b/src/include/commands/sequence.h index 932e20351c4..3f3ba529484 100644 --- a/src/include/commands/sequence.h +++ b/src/include/commands/sequence.h @@ -69,6 +69,8 @@ extern Datum setval_oid(PG_FUNCTION_ARGS); extern Datum setval3_oid(PG_FUNCTION_ARGS); extern Datum lastval(PG_FUNCTION_ARGS); +extern Datum pg_sequence_parameters(PG_FUNCTION_ARGS); + extern void DefineSequence(CreateSeqStmt *stmt); extern void AlterSequence(AlterSeqStmt *stmt); extern void ResetSequence(Oid seq_relid); |