| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Cc: | david(at)fetter(dot)org, <kzak(at)redhat(dot)com>, <hsn(at)netmag(dot)cz> |
| Subject: | Oracle date type compat. functions: next_day, last_day, .. |
| Date: | 2005-05-24 17:16:26 |
| Message-ID: | Pine.LNX.4.44.0505241904450.17898-200000@kix.fsv.cvut.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Hello
This patch is implementation of some date functions which produce better
compatibility with Oracle (On request Radim Kolar). Major changes are in
/src/backend/utils/adt/oracle_compat.c. There are new functions: next_day,
last_day, add_months and months_between.
Original Oracle doc
http://www.techonthenet.com/oracle/functions/add_months.htm
http://www.techonthenet.com/oracle/functions/last_day.htm
http://www.techonthenet.com/oracle/functions/next_day.htm
http://www.techonthenet.com/oracle/functions/months_between.htm
Best regards
Pavel Stehule
| Attachment | Content-Type | Size |
|---|---|---|
| oracledate.diff | text/plain | 15.0 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-05-24 17:33:34 | Re: plperl tests for currently untested features |
| Previous Message | Tom Lane | 2005-05-24 17:09:34 | Re: plperl tests for currently untested features |