Postgres Pro
Downloads
Home   >   mailing lists

setting the timezone parameter with space cause diff result - Mailing list pgsql-bugs

From 甄明洋
Subject setting the timezone parameter with space cause diff result
Date
Msg-id 37c04704.1327.179eab261fd.Coremail.zhenmingyang@yeah.net
Whole thread Raw
Responses Re: setting the timezone parameter with space cause diff result  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
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=#


 

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17050: cursor with for update + commit in loop
Next
From: PG Bug reporting form
Date:
Subject: BUG #17051: Incorrect params inferred on PREPARE