contradicts the report
of Oracle 8's behavior that we had earlier from Roland Roberts.
Can someone explain why the different results?
Mike Roland used an anonymous PL/SQL procedure:
You're right and I didn't think enough about what was happening. This
also explains why I so often see
Bruce == Bruce Momjian [EMAIL PROTECTED] writes:
Well, arguably if you're setting up a database server then a
reasonable DBA should think about such things...
Bruce Yes, but people have trouble installing PostgreSQL. I
Bruce can't imagine walking them through a newfs.
In
Ron == Ron de Jong [EMAIL PROTECTED] writes:
Ron Any idea to get a human readable list with column
Ron descriptions like type,size,key,default,null.
Ron It would be nice if it would look simular to the mysql
Ron variant:
You'll need to write your own query to get it to look
"Peter" == Peter Eisentraut [EMAIL PROTECTED] writes:
Peter The POSIX numbering (0-6) is actually pretty slick because
Peter it allows both versions to work: In the U.S. (e.g.) you get
Peter a natural order starting at 0, in Germany (e.g.) you get
Peter Monday as #1.
Oracle's
"AZ" == Zeugswetter Andreas SB [EMAIL PROTECTED] writes:
Unix day-of-week starts on Sunday, not Monday, which is what
date_trunc('dow',...) returns. Presumably this is modeled on
the traditional notion (at least in the US; I suspect this is
true in most European countries at