From: | "Erik Rijkers" <er(at)xs4all(dot)nl> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | extract('dow', ...) mention |
Date: | 2009-11-15 21:50:15 |
Message-ID: | 79ebe278e7d939038c509b1f55d5bebd.squirrel@webmail.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers |
Hi,
It seems to me this mention of extract()
in the manual (chapter 9.8):
extract('dow', ...)
is better replaced with
extract(dow from ...)
( 8.3, 8.4, HEAD )
hth
Erik Rijkers
--- doc/src/sgml/func.sgml.orig 2009-11-15 21:58:02.000000000 +0100
+++ doc/src/sgml/func.sgml 2009-11-15 21:59:16.000000000 +0100
@@ -5274,9 +5274,9 @@
<listitem>
<para>
<function>to_char(..., 'ID')</function>'s day of the week numbering
- matches the <function>extract('isodow', ...)</function> function, but
+ matches the <function>extract(isodow from ...)</function> function, but
<function>to_char(..., 'D')</function>'s does not match
- <function>extract('dow', ...)</function>'s day numbering.
+ <function>extract(dow from ...)</function>'s day numbering.
</para>
</listitem>
From | Date | Subject | |
---|---|---|---|
Next Message | shohorab hossain | 2009-11-17 19:25:51 | Postgresql Database Lock Problem |
Previous Message | Bruce Momjian | 2009-11-13 19:49:20 | vacuumdb clarification |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-11-15 21:55:38 | Re: patch - Report the schema along table name in a referential failure error message |
Previous Message | Tom Lane | 2009-11-15 21:48:11 | Re: Listen / Notify rewrite |