Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 679ED2E00BD for ; Thu, 21 Feb 2008 21:50:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 14162-10 for ; Thu, 21 Feb 2008 21:50:33 -0400 (AST) Received: from epo-int2.asu.edu (epo-int2.asu.edu [129.219.187.21]) by postgresql.org (Postfix) with ESMTP id B9A392E00C1 for ; Thu, 21 Feb 2008 21:50:40 -0400 (AST) Received: from [129.219.57.30] ([129.219.57.30]) by epo-int2.asu.edu (Switch-3.1.8/Switch-3.1.7/asu-postoffice-prod) with ESMTP id m1M1oY3a002249 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=NO) for ; Thu, 21 Feb 2008 18:50:34 -0700 From: David Bear To: pgsql-admin@postgresql.org Subject: creating column content from entry values Date: Thu, 21 Feb 2008 18:55:30 -0700 User-Agent: KMail/1.9.5 Organization: College of Public Programs MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200802211855.30789.david.bear@asu.edu> X-Virus-Scanned: by amavisd-new X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/263 X-Sequence-Number: 28337 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