From: Louise Catherine <r1c4n@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: about subselect
Date: Thu, 11 Aug 2005 20:38:30 -0700 (PDT)
Message-ID: <20050812033830.80532.qmail@web33414.mail.mud.yahoo.com> (raw)
Hi,
I make a subquery test at postgresql
7.3.3 and postgresql 8.0.3.
I found that postgresql 8.0.3 can't do this,
while at postgresql 7.0.3 it works quite well :
create table temp_hasil2(
nojob numeric,
nik numeric,
tanggal numeric,
kdpt numeric,
kdljr numeric
);
create table ap012(
nojob numeric,
tglavd numeric,
ptcd numeric
);
create table am382(
nojob numeric,
nik numeric,
tglavd numeric,
lkrjacd numeric
);
Update Temp_hasil2 Set KdPT = A.PTCD,
KdLjr = A.LKRJACD
From (Select A38.NIK,A01.ptcd,A38.Lkrjacd
From AM382 A38
inner join
ap012 A01 on A38.nojob = A01.nojob
Where A38.tglavd =
(select max(B38.tglavd) from am382 B38
where A38.nik = B38.nik
and B38.tglavd <= Temp_hasil2.Tanggal)
And A01.tglavd =
(select max(B01.tglavd) from ap012 B01
where A01.nojob = B01.nojob
and B01.tglavd <= A38.tglavd)
)A
Where Temp_hasil2.NIK = A.NIK;
If I run this query at Postgresql 8.0.3 :
Error: ERROR: subquery in FROM may
not refer to other relations of same query level.
Can someone help me solve this?,
because I've a plan to migrate database
from postgresql 7.3.3 to postgresql 8.0.3,
and I have a lot of case like one above
at my postgresql 7.3.3 databases.
Thanks,
Louise Catherine
NB: Sorry for my poor English
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: r1c4n@yahoo.com
Subject: Re: about subselect
In-Reply-To: <20050812033830.80532.qmail@web33414.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox