[DOCS] Week numbering

2004-12-06 Thread Troels Arvin
Hello, I was recently surprised to find that EXTRACT's day of the week numbering is different than TO_CHAR's ditto. EXTRACT starts at 0==Sunday while TO_CHAR starts at 1==Sunday. A suggestion for two documentation notes is attached as a patch to current CVS HEAD. -- Greetings from Tr

Re: [DOCS] ANSI SQL-2003 conformance

2004-11-21 Thread Troels Arvin
On Tue, 16 Nov 2004 02:05:36 +, Simon Riggs wrote: >> My best shot is still >> http://troels.arvin.dk/db/pgsql/conformance/pgsql-sql-conformance.patch > I've re-written the starting paragraphs, will post soon. Did you post them, in that case: where? -- Greetin

Re: [DOCS] ANSI SQL-2003 conformance

2004-11-15 Thread Troels Arvin
ved in, and will probably not time to work more on this :-( Simon/Elein: Do you plan to put more work into this? If noone has the time to look over those probably-not-conforming-but-just-maybe features, I suggest that we just go along with the above patch. -- Greetings from Troe

Re: [DOCS] SQL 2003 conformance

2004-10-20 Thread Troels Arvin
nt for sequences, one might say that it's important for the syntax to be equal here. -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subsc

Re: [DOCS] SQL 2003 conformance

2004-10-19 Thread Troels Arvin
tandard/2003/sql:2003-features.sql -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [DOCS] SQL 2003 conformance

2004-10-18 Thread Troels Arvin
) stuff that I'm unsure of: http://troels.arvin.dk/db/pgsql/conformance/in-doubt-features.txt I have also started a little list of SQL:2003 features that I think might be relatively easy to implement in PostgreSQL: http://troels.arvin.dk/db/pgsql/conformance/low-hanging-fruits.txt -- Greeting

Re: [DOCS] Some developer FAQ links need updating

2004-10-14 Thread Troels Arvin
SQL:2003, by the way? (SQL:2003 was ratified early 2004.) -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [DOCS] SQL 2003 conformance

2004-10-14 Thread Troels Arvin
eatures were added or revised for SQL 2003 conformance, so it > would be nice to have that documented for the 8.0 release. True. I'll try putting some time into it. Elein, we could possibly discus some of the issues that might come up on the freenode channel? -- Greetings from Troels Arvin,

[DOCS] LOCALTIMESTAMP should be mentioned in datatype-datetime.html

2003-10-01 Thread Troels Arvin
RRENT_TIME, CURRENT_TIMESTAMP, LOCALTIME and LOCALTIMESTAMP. (See Section 9.8.4.) -- Greetings from Troels Arvin, Copenhagen, Denmark ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourE