diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 8 | ||||
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 10 | ||||
| -rw-r--r-- | doc/src/sgml/release.sgml | 4 |
3 files changed, 12 insertions, 10 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index a59b59211b2..942bd83c782 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.159 2003/07/15 19:19:55 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/func.sgml,v 1.160 2003/07/17 00:55:36 tgl Exp $ PostgreSQL documentation --> @@ -5016,16 +5016,16 @@ SELECT EXTRACT(SECOND FROM TIME '17:12:28.5'); </screen> </listitem> </varlistentry> -<!-- <varlistentry> <term><literal>timezone</literal></term> <listitem> <para> - The time zone offset. XXX But in what units? + The time zone offset from UTC, measured in seconds. Positive values + correspond to time zones east of UTC, negative values to + zones west of UTC. </para> </listitem> </varlistentry> ---> <varlistentry> <term><literal>timezone_hour</literal></term> diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 7a5c8b51fb7..08ea5f3c2f4 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.78 2003/07/15 19:19:56 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/set.sgml,v 1.79 2003/07/17 00:55:36 tgl Exp $ PostgreSQL documentation --> @@ -182,16 +182,16 @@ SELECT setseed(<replaceable>value</replaceable>); </listitem> </varlistentry> <varlistentry> - <term><literal>7</literal></term> + <term><literal>-7</literal></term> <listitem> <para> The time zone 7 hours west from UTC (equivalent - to PDT). Negative values are east from UTC. + to PDT). Positive values are east from UTC. </para> </listitem> </varlistentry> <varlistentry> - <term><literal>INTERVAL '08:00' HOUR TO MINUTE</literal></term> + <term><literal>INTERVAL '-08:00' HOUR TO MINUTE</literal></term> <listitem> <para> The time zone 8 hours west from UTC (equivalent @@ -205,7 +205,7 @@ SELECT setseed(<replaceable>value</replaceable>); <listitem> <para> Set the time zone to your local time zone (the one that - your operating system defaults to). + the server's operating system defaults to). </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 5164f7155a1..3829d1eb831 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.197 2003/07/15 19:19:55 tgl Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.198 2003/07/17 00:55:36 tgl Exp $ --> <appendix id="release"> @@ -24,6 +24,8 @@ CDATA means the content is "SGML-free", so you can write without worries about funny characters. --> <literallayout><![CDATA[ +EXTRACT(TIMEZONE) and SET/SHOW TIMEZONE now follow SQL sign convention + (positive = east of UTC) Output of SHOW DATESTYLE is now in the same format accepted by SET DATESTYLE PL/Python is now an untrusted language, and is renamed to 'plpythonu' Dollar sign ($) is no longer allowed in operator names |