From: James Orr <james@lrgmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Referencing a view?
Date: Fri, 13 Jul 2001 09:41:16 -0400
Message-ID: <002301c10ba1$90872260$1600000a@lrg.office> (raw)
References: <20010713102221.T415-100000@callisto.internal.linustech.com.cy>
Thanks for all the responses! The one from Grigoriy was particularly
interesting, I hadn't thought of that approach.
However, I came to the realization that if somebody changes their address, I
don't want it to be changed on previous orders. So I think i'll change the
orders table to contain the actual address information and use an INSERT ...
SELECT instead. That way I can be sure I have an accurate record of all
orders.
Thanks!
- James
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: james@lrgmail.com
Subject: Re: Referencing a view?
In-Reply-To: <002301c10ba1$90872260$1600000a@lrg.office>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox