Skip site navigation (1) Skip section navigation (2)

aliasing table name in update

From: Holger Klawitter <holger(at)klawitter(dot)de>
To: pgsql-bugs(at)postgreSQL(dot)org
Subject: aliasing table name in update
Date: 2001-04-10 07:35:24
Message-ID: 3AD2B7BC.8C42B9A9@klawitter.de (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi there,

Upgrading from 7.0.3 to 7.1(rc4) went very smooth - but a small
issue came up:

The following statement does not work any more:
	update l set i=2 from longname l where l.i=1;

Not a big problem, but you should know ;-)

With kind regards / Mit freundlichem Gruß
    Holger Klawitter
--
Holger Klawitter
holger(at)klawitter(dot)de                             http://www.klawitter.de

Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-04-10 16:11:37
Subject: Loss of significant digits on pg_dump
Previous:From: Phil SteinkeDate: 2001-04-09 22:30:17
Subject: Re: date_part returns wrong day for 1974-04-28

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group