On 04/10/2003 12:53:46 AM Ian wrote:
>Again based on my familiarity with MySQL, which doesn't have real
>foreign keys. If you can suggest the changes, to the SQL in particular,
>that would be good. Well, I should probably just read up on it, since
>I'm starting to use Postgres more myself.
It is well worth it Ian. PostgreSQL is very faithful to SQL-92, so what you
learn would apply to Sybase, SQL Server, and even Oracle to some degree.
Once you start using integrity constraints, triggers, etc. to enforce data
semantics, you'll never be able to not use them again. The meaning in a
database is captured in the constraints, not the data.