the following used to work:
create table t1(t1f1 text, t1f2 text, t1f3 text);
create table t2(t2f2 text, t2f3 text);
unfortunately, now I get the error that t2 is not in the FROM clause.
I know I can do
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?
pgsql-general by date
|Next:||From: Nikolay Samokhvalov||Date: 2006-02-28 13:11:50|
|Subject: Re: Sequences/defaults and pg_dump|
|Previous:||From: Douglas McNaught||Date: 2006-02-28 12:28:12|
|Subject: Re: Size comparison between a Composite type and an|