Re: Why is MySQL more chosen over PostgreSQL?
От | Sander Steffann |
---|---|
Тема | Re: Why is MySQL more chosen over PostgreSQL? |
Дата | |
Msg-id | 008301c2386d$301f8d00$8e01a8c0@OFFICE обсуждение исходный текст |
Ответ на | Re: Why is MySQL more chosen over PostgreSQL? (Curt Sampson <cjs@cynic.net>) |
Ответы |
Re: Why is MySQL more chosen over PostgreSQL?
|
Список | pgsql-hackers |
Hi > And what's the problem with networkcard_products being a separate table > that shares a key with the products table? > > CREATE TABLE products (product_id int, ...) > CREATE TABLE networkcard_products_data (product_id int, ...) > CREATE VIEW networkcard_products AS > SELECT products.product_id, ... > FROM products > JOINT networkcard_products_data USING (product_id) > > What functionality does table inheritance offer that this traditional > relational method of doing things doesn't? Well, if you also have soundcard_products, in your example you could have a product which is both a networkcard AND a soundcard. No way to restrict that a product can be only one 'subclass' at a time... If you can make that restriction using the relational model, you can do the same as with subclasses. But afaict that is very hard to do... Sander.
В списке pgsql-hackers по дате отправления: