char(sysdate) advances in a transaction ]
>> Now I'm really confused; this directly 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
> "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 i
> "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
> "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 Europea
> "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.