Tom Lane wrote:
> Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
>
>>Strangely a pgsql to oracle exporter is a good thing. It'd be a great
>>feature of PostgreSQL. Imagine how many people would start on
>>PostgreSQL if they KNEW that one day they could easily move to Oracle if
>>they needed to. Risk management.
>
>
> Problem is: to offer such a thing with a straight face, we'd have to
> confine ourselves to an Oracle-subset version of SQL. For instance,
> lose the ability to distinguish empty-string from NULL.
Oh please PLEASE *PLEASE* don't bend that way. Oracle has some SQL non
compliant flaws at least one is serious: The inability to distinguish
between the absence of value and an explicitly empty string is just ONE
of Oracle's ridiculous fubarness. People who know what a NULL really is
and use it properly have to program around Oracle's stupidity to "dumb
it down" for the weak application developer, let's not do that.
Terry
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
Terry Fielder
terry@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085