creating column content from entry values - Mailing list pgsql-admin

From David Bear
Subject creating column content from entry values
Date
Msg-id 200802211855.30789.david.bear@asu.edu
Whole thread Raw
Responses Re: creating column content from entry values  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Lucas Sanabio"
Date:
Subject: Re: Table was deleted but it still been treated as not
Next
From: Tom Lane
Date:
Subject: Re: creating column content from entry values