RE: Correlated subquery/update

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: RE: Correlated subquery/update
Date: 2001-01-12 16:29:53
Message-ID: NEBBLAAHGLEEPCGOBHDGKEIJCHAA.nickf@ontko.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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);

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-01-12 16:39:22 Re: mnogosearch -- pgsql seem so slow, please help me find out why
Previous Message Tom Lane 2001-01-12 16:24:42 Re: PostgreSQL v7.1BETA3 Bundled and Available ...