Re: [GENERAL] Dynamic update
От | Simon Drabble |
---|---|
Тема | Re: [GENERAL] Dynamic update |
Дата | |
Msg-id | Pine.LNX.4.10.9911031416470.19564-100000@dragon.localdomain обсуждение исходный текст |
Ответ на | Re: [GENERAL] Dynamic update (Alain TESIO <alain_tesio@yahoo.com>) |
Список | pgsql-general |
On Wed, 3 Nov 1999, Alain TESIO wrote: > -- Simon Drabble <simon@eskimo.com> wrote: > > Is it possible to update a column with another column's value, say > > > > UPDATE member SET votes = `SELECT count(votes) FROM ballot WHERE id > > = 1`; > > > > with or without aggregates? > > Have you tried a more direct command ? > > 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 ...) > > Alain I get parse error at or near count - any variation (without the = sign) produces a similar error. TA, Simon. > > __________________________________________________ > Do You Yahoo!? > Bid and sell for free at http://auctions.yahoo.com > -- "Linux - open doors, not windows." Simon Drabble It's like karma for your brain. simon@eskimo.com
В списке pgsql-general по дате отправления: