Postgres Pro
Downloads
Home   >   mailing lists

RE: Correlated subquery/update - Mailing list pgsql-general

From Nick Fankhauser
Subject RE: Correlated subquery/update
Date
Msg-id NEBBLAAHGLEEPCGOBHDGKEIJCHAA.nickf@ontko.com
Whole thread Raw
In response to Correlated subquery/update  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-general
Tree view 
Sounds like the answer is to upgrade to v7+

Much thanks to Tom Lane and Len Morgan for the helpful responses!

-Nick

>update one set b = (select d from two where one.a = two.c);

pgsql-general by date:

Previous
From: "Thomas T. Thai"
Date:
Subject: mnogosearch -- pgsql seem so slow, please help me find out why
Next
From: Tom Lane
Date:
Subject: Re: mnogosearch -- pgsql seem so slow, please help me find out why