| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Jean-Michel POURE <jm(at)poure(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Mapping Oracle types to PostgreSQL types |
| Date: | 2003-10-17 14:43:09 |
| Message-ID: | Pine.LNX.4.33.0310171040030.3392-100000@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-advocacy pgsql-hackers |
On Fri, 17 Oct 2003, Tom Lane wrote:
> Since varchar(n) is SQL-standard syntax, can't you simply adopt the more
> standard name for both databases?
>
A long time ago Oracle made the varchar type equivalent to char and once
people complained about the excess space used by short entries they came
out with varchar2 which they've maintained every since valuing backwards
compatability more than the sql standard.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Michel POURE | 2003-10-17 14:52:20 | Re: Mapping Oracle types to PostgreSQL types |
| Previous Message | Matthew T. O'Connor | 2003-10-17 14:32:10 | Re: Mapping Oracle types to PostgreSQL types |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2003-10-17 14:47:29 | Re: Some thoughts about i/o priorities and throttling vacuum |
| Previous Message | Alvaro Herrera | 2003-10-17 14:41:39 | Re: Some thoughts about i/o priorities and throttling vacuum |