X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 4A374475F00
	for <pgsql-sql@postgresql.org>; Wed, 26 Mar 2003 14:08:45 -0500 (EST)
Received: from smtp.web.de (smtp01.web.de [217.72.192.180])
	by postgresql.org (Postfix) with ESMTP id 482FE475CBC
	for <pgsql-sql@postgresql.org>; Wed, 26 Mar 2003 14:08:44 -0500 (EST)
Received: from p5081885d.dip0.t-ipconnect.de ([80.129.136.93] helo=web.de)
	by smtp.web.de with asmtp (TLSv1:RC4-MD5:128) (WEB.DE(Exim) 4.97 #53)
	id 18yGGO-0001Tz-00; Wed, 26 Mar 2003 20:08:40 +0100
Message-ID: <3E81FAB9.9020708@web.de>
Date: Wed, 26 Mar 2003 20:08:41 +0100
From: Andreas Pflug <Andreas.Pflug@web.de>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030312
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Manfred Koizar <mkoi-pg@aon.at>, pgsql-sql@postgresql.org
Subject: Re: UPDATE FROM portability
References: <3E7F1695.5050101@web.de>
	<8cr38v8fndks17i5d19vr4joe257v480jb@4ax.com>
In-Reply-To: <8cr38v8fndks17i5d19vr4joe257v480jb@4ax.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-21.4 required=5.0
	tests=BAYES_01,IN_REP_TO,RCVD_IN_NJABL,REFERENCES,
	USER_AGENT_MOZILLA_UA autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200303/589
X-Sequence-Number: 12627

Thanks Manfred,

you're right. If written without typo (ahem...:-) MSSQL will execute the 
pgsql syntax correctly.

>AFAIK this should work with MSSQL7.  Assuming you didn't name your
>columns value and key ...
>
>Servus
> Manfred
>
>  
>