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>