pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (6+ messages)  latest in thread

Message-ID: <002301c10ba1$90872260$1600000a@lrg.office>
Permalink:  ../002301c10ba1$90872260$1600000a@lrg.office/
Also on:    postgresql.org/message-id/002301c10ba1$90872260$1600000a@lrg.office

 · 

reply

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