Re: UPDATE FROM portability

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: UPDATE FROM portability
Date: 2003-03-26 18:16:49
Message-ID: 8cr38v8fndks17i5d19vr4joe257v480jb@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Mon, 24 Mar 2003 15:30:45 +0100, Andreas Pflug
<Andreas(dot)Pflug(at)web(dot)de> wrote:
>Updating some rows in tab1 with corresponding values from tab2, pgsql style:
>UPDATE tab1
> SET value=T2.VALUE
> FROM tab2 T2
> WHERE T2.restr=1
> AND tab1.key=T2.key

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

Servus
Manfred

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tony Reina 2003-03-26 18:24:46 How can I pass an array from PostgreSQL to C (libpq)?
Previous Message Jodi Kanter 2003-03-26 18:12:30 order by