From 7e27f2fa571567415f1ea661dd55eb3a900a8acb Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Tue, 18 Dec 2007 15:44:18 +0000 Subject: [PATCH] Add currentSequenceValue() function. --- includes/DatabasePostgres.php | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/includes/DatabasePostgres.php b/includes/DatabasePostgres.php index fa0d6dd7358..48c99dbd8cd 100644 --- a/includes/DatabasePostgres.php +++ b/includes/DatabasePostgres.php @@ -798,6 +798,18 @@ class DatabasePostgres extends Database { } /** + * Return the current value of a sequence. Assumes it has ben nextval'ed in this session. + */ + function currentSequenceValue( $seqName ) { + $safeseq = preg_replace( "/'/", "''", $seqName ); + $res = $this->query( "SELECT currval('$safeseq')" ); + $row = $this->fetchRow( $res ); + $currval = $row[0]; + $this->freeResult( $res ); + return $currval; + } + + /** * Postgres does not have a "USE INDEX" clause, so return an empty string */ function useIndexClause( $index ) { -- 2.11.4.GIT