On 4/19/05, Joel Fradkin <[EMAIL PROTECTED]> wrote:
>
>
>
> update tblcase set merchandisetotal =
>
> (
>
> COALESCE(( SELECT sum(m.quantity::numeric * m.amount) AS merchandiseamount
>
>FROM tblmerchandise m
>
> WHERE m.caseid = tblcase.caseid AND m.clientnum::te
Sent: Dienstag, 19. April 2005
16:06
To: pgsql-sql@postgresql.org
Subject: [SQL] trying to do an
update a bit confused.
update tblcase set
merchandisetotal =
(
COALESCE(( SELECT sum(m.quantity::numeric
* m.amount) AS merchandiseamount
FROM tblmerchandise m
WHERE m.c
You're
most probably missing a Where clause after the parentensis.
see:
-Original Message-From: Joel Fradkin
[mailto:[EMAIL PROTECTED]Sent: Dienstag, 19. April 2005
16:06To: pgsql-sql@postgresql.orgSubject: [SQL] trying
to do an update a bit confused.
update tb
update tblcase set merchandisetotal =
(
COALESCE(( SELECT sum(m.quantity::numeric * m.amount) AS merchandiseamount
FROM tblmerchandise m
WHERE m.caseid = tblcase.caseid AND m.clientnum::text
= tblcase.clientnum::text), 0.0)
)
I tried running the above and it
