Re: [GENERAL] Touch row ?

2004-01-25 Thread Chris Travers
Interestingly enough, a where clause is insufficient to free yourself from the infinite recursion. For example CREATE RULE ON mytable where old.mytimestamp != now() do update mytable set timestamp = now() still infinitely recurses even though on the second attempt one would expect the where

Re: [GENERAL] OT: SCO Extortion

2004-01-25 Thread Chris Travers
RedHat Enterprise IS redistributable, and there are third party distros based on it. However there is one major gotcha: The contract for the enterprise services for RHEL state that every copy of RedHat Enterprise Linux in an organization MUST be signed up for the enterprise services if any one

Re: [GENERAL] Multiway associations

2004-01-25 Thread Paul Thomas
On 25/01/2004 05:06 Russell Shaw wrote: Hi, I'm making my first database. I have a list of parts, each of which is sold by multiple vendors. I also have a list of vendors, each of which sell multiple parts. How should i arrange the tables for this that doesn't involve having lots of empty fields