From: Tom Lane <tgl@sss.pgh.pa.us>
To: David Bear <david.bear@asu.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: creating column content from entry values
Date: Thu, 21 Feb 2008 21:17:38 -0500
Message-ID: <20500.1203646658@sss.pgh.pa.us> (raw)
In-Reply-To: <200802211855.30789.david.bear@asu.edu>
References: <200802211855.30789.david.bear@asu.edu>
David Bear <david.bear@asu.edu> writes:
> Breifly, I want to do an insert where the values for three of the attributes
> are combined via a function and make up the value for the fourth attribute.
Well, there's more than one way to do it. What you didn't tell us is
just how tightly you want to bind column 4 to be func-of-cols-1-2-3.
Do you want it to be purely read-only and always equal to the function
on the current values of the other columns? Do you want to force it
to be that way on initial insertion of the row, but subsequent updates
could allow the columns to diverge? Do you merely want it as a default
that could be overridden during the insert? Also, is the function
expensive enough that you really want to precompute it at insert time
and store the output; or maybe it should be just a "virtual" column
where the function is computed on demand during readout?
Depending on what you think about these questions, you might choose to
not store column 4 physically at all, but just have it be part of a view
wherein the function is computed on-the-fly. Or you could use an ON
INSERT and/or ON UPDATE trigger, perhaps with different degrees of
aggressiveness about whether it overrides a pre-supplied value for
column 4.
regards, tom lane
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-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, david.bear@asu.edu
Subject: Re: creating column content from entry values
In-Reply-To: <20500.1203646658@sss.pgh.pa.us>
* 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