| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
| Cc: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Postgresql likes Tuesday... |
| Date: | 2002-10-01 13:51:12 |
| Message-ID: | 21369.1033480272@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> writes:
> What think about it our Toms?
> ...
> In the Oracle it's same (means WW vs. IW vs. D)
If it works the same as Oracle then I'm happy with it; that's what it's
supposed to do.
The real point here seems to be that EXTRACT(week) corresponds to
to_date's IW conversion, not WW conversion. This is indeed implied by
the docs, but it's not stated plainly (there's just a reference to ISO
in each of the relevant pages). Perhaps we need more documentation, or
a different layout that would offer a place to put notes like this one.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-01 13:59:52 | Re: pg_dump and large files - is this a problem? |
| Previous Message | Philip Warner | 2002-10-01 12:13:04 | pg_dump and large files - is this a problem? |