From: Manuel Trujillo <manueltrujillo@dorna.es>
To: pgsql-sql@postgresql.org
Subject: problems with this wiew
Date: Tue, 4 Dec 2001 12:10:47 +0100
Message-ID: <20011204111047.GA10294@dorna.es> (raw)
Hi.
I've got a problem with this "wiew":
select gallery_id, multimedia_id
from (view_multimedia_file A
inner join ( select gallery_id,
multimedia_id,
element_type_id,
result_type_id,
subevent_id,
subevent_type_id,
event_id,
championship_id,
championship_type_id,
season_id,
c_language_id as language_id
from ( view_gallery B
inner join ( select gallery_id as c_gallery_id,
result_type_id,
subevent_id,
subevent_type_id,
event_id,
championship_id,
championship_type_id,
season_id,
language_id as c_language_id
from view_gallery_result_type
) C
on (B.gallery_id = C.c_gallery_id)
) D
) E
on ( (A.mm_id = E.multimedia_id)
)
);
select *
from (view_multimedia_file A
inner join ( select gallery_id,
multimedia_id,
element_type_id,
result_type_id,
subevent_id,
subevent_type_id,
event_id,
championship_id,
championship_type_id,
season_id,
c_language_id as language_id
from ( view_gallery B
inner join ( select gallery_id as c_gallery_id,
result_type_id,
subevent_id,
subevent_type_id,
event_id,
championship_id,
championship_type_id,
season_id,
language_id as c_language_id
from view_gallery_result_type
) C
on (B.gallery_id = C.c_gallery_id)
) D
) E
on ( (A.mm_id = E.multimedia_id)
)
);
The postgresql show error.
Anybody can help me, please??
Thank you very much.
Have a nice day ;-)
TooManySecrets
--
Manuel Trujillo manueltrujillo@dorna.es
Technical Engineer http://www.motograndprix.com
Dorna Sports S.L. +34 93 4702864
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: manueltrujillo@dorna.es
Subject: Re: problems with this wiew
In-Reply-To: <20011204111047.GA10294@dorna.es>
* 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