| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us, <neilc(at)samurai(dot)com>, <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Subject: | final light versions of Oracle compatibility (SQLSTATE, GREATEST, NEXT_DAY) |
| Date: | 2005-06-07 22:51:40 |
| Message-ID: | Pine.LNX.4.44.0506080038340.28427-400000@kix.fsv.cvut.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
Hello,
The first, I am sorry for my confusions. I hope this patches are
final. I recapitulate it.
1. SQLSTATE and SQLERRM exists only on exception's block, and allways
carry info about some exception.
2. Implementation of greatest and least lost function decode. Function
decode has analogy in CASE and not is implemented now.
3. ADD_MONTH is easy implemented via interval aritmetic, MONTHS_BETWEEN
are really Oracle specific, stayed out, I will be maintain these functions
in pgfoundry. NEXT_DAY and LAST_DAY are generally usefull (I hope).
Regards
Pavel Stehule
| Attachment | Content-Type | Size |
|---|---|---|
| sqlstate.diff | text/plain | 12.8 KB |
| oradfunc.diff | text/plain | 11.1 KB |
| greatest.sql | text/plain | 23.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-06-07 23:00:48 | Re: Are you actively hacking on 2PC? |
| Previous Message | Alvaro Herrera | 2005-06-07 21:58:42 | Re: Are you actively hacking on 2PC? |