update from select

Поиск
Список
Период
Сортировка
От Gary Stainburn
Тема update from select
Дата
Msg-id 200310290911.54453.gary.stainburn@ringways.co.uk
обсуждение исходный текст
Ответы Re: update from select  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-sql
Hi folks,

don't know if it's cos of the 17 hours I've just worked (sympathy vote please) 
but I can't get this one worked out

I've got table names with nid as name id field and nallowfollow flag.
I've got a vehicles table with vowner pointing at nid and a vallowfollow 
field.

How can I update nallowfollow from the appropriate vallowfollow flag?
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Table versions
Следующее
От: Jeff Kowalczyk
Дата:
Сообщение: Help on update that subselects other records in table, uses joins