Re: question on UPDATE TABLE
От | Wei Weng |
---|---|
Тема | Re: question on UPDATE TABLE |
Дата | |
Msg-id | 1030132646.29122.10.camel@Monet обсуждение исходный текст |
Ответ на | Re: question on UPDATE TABLE (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Список | pgsql-sql |
Thanks a lot! It works. :) On Fri, 2002-08-23 at 15:51, Stephan Szabo wrote: > On 23 Aug 2002, Wei Weng wrote: > > > I have this query > > > > UPDATE ONLY ContentSummaries > > SET AccessID = '685d96de-1d09-11b2-beec-0001031d54ce' > > FROM Categories AS cat, ContentTypes AS ct, ContentSummaries AS cs LEFT > > OUTER JOIN Publishers AS pb ON (pb.PublisherID = cs.PublisherID) > > WHERE cs.CreationDate IS NOT NULL AND cat.CategoryID = cs.CategoryID AND > > ct.ContentTypeID = cs.ContentTypeID AND cat.CategoryID = > > '391b11d0-1d09-11b2-a312-0001031d54ce' > > You do realize you're getting two copies of ContentSummaries in this > update and only one is actually being constrained afaics (and it's not the > one being updated). Perhaps something like > cs.ContentTypeID=ContentSummaries.ContentTypeID or something like that > in the where clause? > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Wei Weng Network Software Engineer KenCast Inc.
В списке pgsql-sql по дате отправления: