Re: Fields - Mailing list pgsql-jdbc

From Mark Lewis
Subject Re: Fields
Date
Msg-id 1149108973.20798.3.camel@archimedes
Whole thread Raw
In response to Re: Fields  ("Guy Rouillier" <guyr@masergy.com>)
Responses Re: Fields
List pgsql-jdbc
On Wed, 2006-05-31 at 15:51 -0500, Guy Rouillier wrote:
> Charles Curi wrote:
> > Hi people!!!
> > I have a table called "orders" with fields "a","b" and "c".
> > I want to make a INSERT only of fields "a" and "b" by Java and at
> > this moment c=a*b; Is it possible?
>
> I think you are saying you want your Java code to insert fields "a" and
> "b" and have "c" automatically set to a value derived from "a" and "b".
> If so, you can accomplish this with an insert trigger.
>

Or you could just insert a, b and a*b yourself . . . . or am I missing
something here?

-- Mark

pgsql-jdbc by date:

Previous
From: "Guy Rouillier"
Date:
Subject: Re: Fields
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: granted select works in psql but not via jdbc