On Thu, Mar 20, 2008 at 7:08 PM, Joe <
dev@freedomcircle.net> wrote:
Gurjeet Singh wrote:
> Except that it doesn't work... Did you try to execute that query; I am
> assuming not.
Of course I did,
My bad... I did not run your query either, and based my assumption on my previous attempt that had thrown an error. Here's something similar to what had failed in my previous attemt:
update t1
as e1 set e1.col2 = t1copy.col2, e1.col3 = t1copy.col3
from t1 as t1copy
where e1.col1 = 1 and t1copy.col1 = 3;
As you can see, I had aliased the main table t1, and hence the error.
Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB
http://www.enterprisedb.com17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad *
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco
http://gurjeet.frihost.netMail sent from my BlackLaptop device
