diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-17 00:55:37 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2003-07-17 00:55:37 +0000 |
| commit | 764f72dc823edb3f8bdf387501ce4c12dedd2369 (patch) | |
| tree | 01838a17f094eb1ac2a0f99102002adbff063605 /src/include/miscadmin.h | |
| parent | 93236b58e088cd2151540528d484da9ad82e48c8 (diff) | |
Make EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE follow the SQL convention
for the sign of timezone offsets, ie, positive is east from UTC. These
were previously out of step with other operations that accept or show
timezones, such as I/O of timestamptz values.
Diffstat (limited to 'src/include/miscadmin.h')
| -rw-r--r-- | src/include/miscadmin.h | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/src/include/miscadmin.h b/src/include/miscadmin.h index 213d2581333..cfe065ffcf0 100644 --- a/src/include/miscadmin.h +++ b/src/include/miscadmin.h @@ -12,7 +12,7 @@ * Portions Copyright (c) 1996-2002, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $Id: miscadmin.h,v 1.125 2003/06/27 19:08:38 tgl Exp $ + * $Id: miscadmin.h,v 1.126 2003/07/17 00:55:37 tgl Exp $ * * NOTES * some of the information in this file should be moved to @@ -147,7 +147,9 @@ extern DLLIMPORT Oid MyDatabaseId; * EuroDates if client prefers dates interpreted and written w/European conventions. * * HasCTZSet is true if user has set timezone as a numeric offset from UTC. - * If so, CTimeZone is the timezone offset in seconds. + * If so, CTimeZone is the timezone offset in seconds (using the Unix-ish + * sign convention, ie, positive offset is west of UTC, rather than the + * SQL-ish convention that positive is east of UTC). */ #define MAXTZLEN 10 /* max TZ name len, not counting tr. null */ |