Re: [HACKERS] (Fwd) Re: Any Oracle 9 users? A test please...

2002-10-04 Thread Roland Roberts
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

Re: [HACKERS] Re: New Linux xfs/reiser file systems

2001-05-04 Thread Roland Roberts
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

Re: [HACKERS] Is there no DESCRIBE TABLE; on PGSQL? help!!!

2001-10-23 Thread Roland Roberts
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

Re: [HACKERS] Re: Week number

2001-03-14 Thread Roland Roberts
"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

Re: AW: [HACKERS] Re: Week number

2001-03-14 Thread Roland Roberts
"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