Re: Mapping Oracle types to PostgreSQL types - Mailing list pgsql-hackers

From Kris Jurka
Subject Re: Mapping Oracle types to PostgreSQL types
Date
Msg-id Pine.LNX.4.33.0310171040030.3392-100000@leary.csoft.net
Whole thread Raw
In response to Re: Mapping Oracle types to PostgreSQL types  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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




pgsql-hackers by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: Some thoughts about i/o priorities and throttling vacuum
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: Some thoughts about i/o priorities and throttling vacuum