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



view thread (3+ messages)  latest in thread

Message-ID: <200802211855.30789.david.bear@asu.edu>
Permalink:  ../200802211855.30789.david.bear@asu.edu/
Also on:    postgresql.org/message-id/200802211855.30789.david.bear@asu.edu

 · 

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-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