| From: | "Xavier Poinsard" <xpoinsard(at)free(dot)fr> |
|---|---|
| To: | pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Two bugs found (and patch included) |
| Date: | 2005-01-17 15:23:17 |
| Message-ID: | 41EBD865.20507@free.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
I just discovered two bugs and attached a patch to correct them :
- the jdbc escaped scalar function dayofweek should return values
between 1 and 7 (1 for sunday) unlike the backend "extract dow" function
- the literal escaped values for date/time/timestamp were not explicitly
casted and causing some problems : for example
extract( dow from '2005-01-17 12:00:00')
generate an error, but the following is accepted
extract( dow from TIMESTAMP '2005-01-17 12:00:00')
Xavier Poinsard.
| Attachment | Content-Type | Size |
|---|---|---|
| patchDOWandTSbugs.txt | text/plain | 3.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nico | 2005-01-17 16:46:58 | control action query |
| Previous Message | Guillaume Cottenceau | 2005-01-17 14:04:08 | Re: Problem : Japanese Character Support |