Re: [GENERAL] Inheritance question

2009-01-16 Thread Erik Jones
On Jan 16, 2009, at 9:49 AM, Glyn Astill wrote: Hi chaps, I've got a question about inheritance here, and I think I may have gotten the wrong end of the stick as to how it works, or at least when to use it. What I intended to do was have a schema "audit" with an empty set of tables in

[GENERAL] Inheritance question

2009-01-16 Thread Glyn Astill
Hi chaps, I've got a question about inheritance here, and I think I may have gotten the wrong end of the stick as to how it works, or at least when to use it. What I intended to do was have a schema "audit" with an empty set of tables in it, then each quarter restore our audit data into schemas

Re: [GENERAL] Inheritance question

2007-05-30 Thread Andrew Sullivan
On Thu, May 24, 2007 at 04:44:53PM -0700, Raymond C. Rodgers wrote: > The question, and point, is this: Is there an alternate way of > accomplishing read and write functionality similar to what inheritance > offers but allowing me to map the columns as I desire? The read only It isn't clear fro

[GENERAL] Inheritance question

2007-05-28 Thread Raymond C. Rodgers
First, I want to confess that I am not an SQL expert or even remotely close. :-) Second, I believe I pretty much know the answer to my question, but I would like to have some confirmation if you fine people don't mind. My situation is this: I have a PHP script that some what dynamically genera

[GENERAL] Inheritance question

2007-05-24 Thread Raymond C. Rodgers
First, I want to confess that I am not an SQL expert or even remotely close. :-) Second, I believe I pretty much know the answer to my question, but I would like to have some confirmation if you fine people don't mind. My situation is this: I have a PHP script that some what dynamically generates

[GENERAL] Inheritance question

2001-04-18 Thread msteele
Hi folks, I've got a question regarding inheritance. What are the advantages of using inheritance in the database structure as opposed to using foreign keys? Doesn't interitance mean that there will be much more duplication of data in the database? If anyone has any examples of proper usage of