From: | Simon Drabble <simon(at)eskimo(dot)com> |
---|---|
To: | "Aaron J(dot) Seigo" <aaron(at)gtv(dot)ca> |
Cc: | tesio(at)easynet(dot)fr, Alain TESIO <alain_tesio(at)yahoo(dot)com>, Postgres Group <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Dynamic update |
Date: | 1999-11-03 19:59:00 |
Message-ID: | Pine.LNX.4.10.9911031457060.20174-100000@dragon.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, 3 Nov 1999, Aaron J. Seigo wrote:
> hi...
>
> just tested this:
>
> > UPDATE member SET votes count(votes) FROM ballot WHERE id = 1 ;
> >
> > (I can't test right now but I don't see why this wouldn't work ...)
>
> genisys=> UPDATE members SET phone1 = deadmem.phone1 FROM deadmem WHERE deadmem.id_num = 7356 and
> genisys-> members.id_num = 100;
> UPDATE 1
>
> with an '=' and defining which field belongs to which table it works! =) kudos
> to alain...
>
> --
> Aaron J. Seigo
> Sys Admin
>
Thanks Aaron (and others), that got it - I was missing the table. part of the
column specifier, and also I was trying to update an empty table - oops.
I knew there had to be a way - thanks once again.
Simon
--
"Linux - open doors, not windows."
Simon Drabble It's like karma for your brain.
simon(at)eskimo(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Drabble | 1999-11-03 20:04:34 | Functions |
Previous Message | Chris Teli | 1999-11-03 19:41:08 | Real Time Applications |