Tom Lane wrote:
Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
