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

implicit tables syntax disappeared from 8.0->8.1

From: pg(at)os10000(dot)net
To: "PG Users" <pgsql-general(at)postgresql(dot)org>
Subject: implicit tables syntax disappeared from 8.0->8.1
Date: 2006-02-28 13:01:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

the following used to work:

create table t1(t1f1 text, t1f2 text, t1f3 text);
create table t2(t2f2 text, t2f3 text);

insert ...

update   t1
set  t1f1='test'
where  t1.t1f2=t2.t2f2
and  t1.t1f3=t2.t2f3;

unfortunately, now I get the error that t2 is not in the FROM clause.

I know I can do

update t1
set t1f1='test'
where t1.t1f2||'/'||t1.t1f3 in
(select t2.t2f2||'/'||t2.t2f3 from t2);

But I'm afraid that's very expensive.  Do you have a suggestion for
alternative syntax for my initial query?

Thank you,

Oliver Seidel


pgsql-general by date

Next:From: Nikolay SamokhvalovDate: 2006-02-28 13:11:50
Subject: Re: Sequences/defaults and pg_dump
Previous:From: Douglas McNaughtDate: 2006-02-28 12:28:12
Subject: Re: Size comparison between a Composite type and an

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