From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | "Hillensbeck, Preston" <PHillensbeck(at)sfbcic(dot)com> |
Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: INSERT & UPDATE |
Date: | 2002-04-20 00:01:40 |
Message-ID: | 20020420100140.B23721@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Apr 19, 2002 at 01:44:55PM -0500, Hillensbeck, Preston wrote:
> I am trying to UPDATE a column after an INSERT, and getting a NULL result,
> let me show you some code... This is from a PHP page by the way
>
> $sql="BEGIN WORK; INSERT INTO checking (check_date, check_amount,
> check_number, check_payee, check_trans_type) VALUES ('$check_date',
> '$check_amount', '$check_number', '$check_payee', '$check_trans_type');
> UPDATE checking SET check_post_balance = (check_pre_balance -
> $check_amount::money); COMMIT WORK;";
>
> After the INSERT, I am trying to update the check_post_balance column to
> check_pre_balance MINUS what the check_amount was. I have tried many
> variations on this and all I get are NULL results. Can anyone see what in
> the heck I am doing wrong? :) Thanks in advance!
I imagine the you get NULL out because check_pre_balance is also NULL?
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America
From | Date | Subject | |
---|---|---|---|
Next Message | Curt Sampson | 2002-04-20 01:53:44 | Re: Backup very large databases |
Previous Message | Alex Krohn | 2002-04-19 22:12:56 | Re: unable to repair table: missing chunk number |