setting the timezone parameter with space cause diff result

From: 甄明洋 <zhenmingyang(at)yeah(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: setting the timezone parameter with space cause diff result
Date: 2021-06-08 08:17:09
Message-ID: 37c04704.1327.179eab261fd.Coremail.zhenmingyang@yeah.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

steps ro reproduce:
postgres=# set timezone='+04:00';
SET
postgres=# select now();
now
-------------------------------
2021-06-08 04:14:26.994218-04
(1 row)

/* timezone string with space */
postgres=# set timezone=' +04:00 ';
SET
postgres=# select now();
now
-------------------------------
2021-06-08 05:14:36.486693-03
(1 row)

postgres=#

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-06-08 09:56:58 BUG #17051: Incorrect params inferred on PREPARE
Previous Message PG Bug reporting form 2021-06-08 07:49:25 BUG #17050: cursor with for update + commit in loop