| From: | Brendan Jurd <direvus(at)gmail(dot)com> |
|---|---|
| To: | Jeremy Ford <jeremford(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4862: different results in to_date() between 8.3.7 & 8.4.RC1 |
| Date: | 2009-06-22 07:33:24 |
| Message-ID: | 37ed240d0906220033g46e5600cu626edc67f8296498@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
2009/6/22 Jeremy Ford <jeremford(at)gmail(dot)com>:
> Hi Brendan.
>
> Results as requested - Oracle 10g:
Cheers for that Jeremy.
I think we can safely conclude from these results that Oracle pays no
attention whatsoever to leading spaces in either the input string, or
the format string.
If we want to copy this behaviour, I think the best way forward is to
add some code that deliberately skips over any initial whitespace in
either string. Any comments about this approach? I should be able to
work up a patch over the next couple days.
Cheers,
BJ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lars Kanis | 2009-06-22 09:23:22 | BUG #4869: No proper initialization of OpenSSL-Engine in libpq |
| Previous Message | Dave Page | 2009-06-22 07:29:59 | Re: BUG #4785: Installation fails |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2009-06-22 07:52:47 | Re: 8.4 open item: copy performance regression? |
| Previous Message | Jeremy Ford | 2009-06-22 07:21:30 | Re: BUG #4862: different results in to_date() between 8.3.7 & 8.4.RC1 |