From: David Bear <david.bear@asu.edu>
To: pgsql-admin@postgresql.org
Subject: creating column content from entry values
Date: Thu, 21 Feb 2008 18:55:30 -0700
Message-ID: <200802211855.30789.david.bear@asu.edu> (raw)
I am too new to this environment to know what to call what I want to do.
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.
The function may be a simple as a concatenation, or I may want to do other
things to manipulate the strings that are entered. I think what I want is a
function that I can call when I do the insert like this
insert into mytable (col1, col2, col3) values ('somestring', 'another
string' )
but have the insert fix col3 to be whatever it the function computes it to be.
does this make any sense?
--
David Bear
College of Public Programs/ASU
411 N Central, Phoenix, AZ 85004
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: david.bear@asu.edu
Subject: Re: creating column content from entry values
In-Reply-To: <200802211855.30789.david.bear@asu.edu>
* 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