From: | "EBIHARA, Yuichiro" <ebihara(at)iplocks(dot)co(dot)jp> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Fields |
Date: | 2006-06-01 01:14:22 |
Message-ID: | 001901c68518$b7cd6b40$360aa8c0@ipljp.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
Another solution may be a view as follows.
create table orders (a int, b int);
create view orders_v as select a, b, a * b as c from orders;
ebi
> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Mark Lewis
> Sent: Thursday, June 01, 2006 5:56 AM
> To: Guy Rouillier
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] Fields
>
>
> 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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | J. | 2006-06-01 07:10:08 | Re: granted select works in psql but not via jdbc |
Previous Message | Euler Taveira de Oliveira | 2006-05-31 23:42:20 | Re: granted select works in psql but not via jdbc |