postgres.git / summary / log / commit / refs

commit    543f36b43d835c819c24b2952ac4ecabbdf2b944
Author:   John Naylor <john.naylor@postgresql.org>
Date:     Tue Aug 31 18:15:22 2021 +0000

    Mark the timestamptz variant of date_bin() as stable
    
    Previously, it was immutable by lack of marking. This is not
    correct, since the time zone could change.
    
    Bump catversion
    
    Discussion: https://www.postgresql.org/message-id/CAFBsxsG2UHk8mOWL0tca%3D_cg%2B_oA5mVRNLhDF0TBw980iOg5NQ%40mail.gmail.com
    Backpatch to v14, when this function came in


 src/include/catalog/catversion.h | 2 +-
 src/include/catalog/pg_proc.dat  | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h
index 876583adaa6..21b6648f5ad 100644
--- a/src/include/catalog/catversion.h
+++ b/src/include/catalog/catversion.h
@@ -53,6 +53,6 @@
  */
 
 /*							yyyymmddN */
-#define CATALOG_VERSION_NO	202108031
+#define CATALOG_VERSION_NO	202108311
 
 #endif
diff --git a/src/include/catalog/pg_proc.dat b/src/include/catalog/pg_proc.dat
index b603700ed9d..4f170eaf48c 100644
--- a/src/include/catalog/pg_proc.dat
+++ b/src/include/catalog/pg_proc.dat
@@ -5912,7 +5912,7 @@
   proargtypes => 'interval timestamp timestamp', prosrc => 'timestamp_bin' },
 { oid => '6178',
   descr => 'bin timestamp with time zone into specified interval',
-  proname => 'date_bin', prorettype => 'timestamptz',
+  proname => 'date_bin', provolatile => 's', prorettype => 'timestamptz',
   proargtypes => 'interval timestamptz timestamptz',
   prosrc => 'timestamptz_bin' },
 


[parent: bd3611db5a6f]