pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedproblems with this wiew
5+ messages / 4 participants
[nested] [flat]
* problems with this wiew
@ 2001-12-04 11:10 Manuel Trujillo <manueltrujillo@dorna.es>
0 siblings, 1 reply; 5+ messages in thread
From: Manuel Trujillo @ 2001-12-04 11:10 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: problems with this wiew
@ 2001-12-04 18:07 Stephan Szabo <sszabo@megazone23.bigpanda.com>
parent: Manuel Trujillo <manueltrujillo@dorna.es>
0 siblings, 1 reply; 5+ messages in thread
From: Stephan Szabo @ 2001-12-04 18:07 UTC (permalink / raw)
To: Manuel Trujillo <manueltrujillo@dorna.es>; +Cc: pgsql-sql
On Tue, 4 Dec 2001, Manuel Trujillo wrote:
> Hi.
>
> I've got a problem with this "wiew":
I'm probably missing something obvious, but
in any case the schema for tables and views
involved (preferably in create statements),
your PostgresQL version and the actual error
message you're getting would help us.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: problems with this wiew
@ 2001-12-04 22:31 Aasmund Midttun Godal <postgresql@envisity.com>
parent: Stephan Szabo <sszabo@megazone23.bigpanda.com>
0 siblings, 2 replies; 5+ messages in thread
From: Aasmund Midttun Godal @ 2001-12-04 22:31 UTC (permalink / raw)
To: sszabo@megazone23.bigpanda.com; +Cc: manueltrujillo@dorna.es; pgsql-sql
Well if you have spelled view "wiew" - that may be part of your problem,
sincerely,
Aasmund.
On Tue, 4 Dec 2001 10:07:17 -0800 (PST), Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
> On Tue, 4 Dec 2001, Manuel Trujillo wrote:
>
>
> I'm probably missing something obvious, but
> in any case the schema for tables and views
> involved (preferably in create statements),
> your PostgresQL version and the actual error
> message you're getting would help us.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: problems with this wiew
@ 2001-12-05 15:07 Masaru Sugawara <rk73@echna.ne.jp>
parent: Aasmund Midttun Godal <postgresql@envisity.com>
1 sibling, 0 replies; 5+ messages in thread
From: Masaru Sugawara @ 2001-12-05 15:07 UTC (permalink / raw)
To: Manuel Trujillo <manueltrujillo@dorna.es>; +Cc: pgsql-sql
On Tue, 04 Dec 2001 22:31:21 GMT
"Aasmund Midttun Godal" <postgresql@envisity.com> wrote:
> Well if you have spelled view "wiew" - that may be part of your problem,
>
> sincerely,
>
> Aasmund.
> On Tue, 4 Dec 2001 10:07:17 -0800 (PST), Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
> > On Tue, 4 Dec 2001, Manuel Trujillo wrote:
> >
> >
> > I'm probably missing something obvious, but
> > in any case the schema for tables and views
> > involved (preferably in create statements),
> > your PostgresQL version and the actual error
> > message you're getting would help us.
> >
> Aasmund Midttun Godal
>
> aasmund@godal.com - http://www.godal.com/
> +47 40 45 20 46
>
I would think his problem is cased by how to use aliases, at least, D is
apparently unnecessary. Since I don't know the definitions of his tables,
I can't affirm what type of an error happened. But if his tables are
correctly defined, his error is probably:
ERROR: Column reference "***" is ambiguous.
If so, the vague columns reference of his query ought to be adjusted
with explicitly using aliases: B, C, and E (e.g. see below).
select E.gallery_id, E.multimedia_id
from view_multimedia_file A
inner join (select B.gallery_id,
B.multimedia_id,
B.element_type_id,
C.result_type_id,
C.subevent_id,
C.subevent_type_id,
C.event_id,
C.championship_id,
C.championship_type_id,
C.season_id,
C.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)
) E
on (A.mm_id = E.multimedia_id)
;
Regards,
Masaru Sugawara
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: problems with this wiew
@ 2001-12-05 15:16 Masaru Sugawara <rk73@echna.ne.jp>
parent: Aasmund Midttun Godal <postgresql@envisity.com>
1 sibling, 0 replies; 5+ messages in thread
From: Masaru Sugawara @ 2001-12-05 15:16 UTC (permalink / raw)
To: Manuel Trujillo <manueltrujillo@dorna.es>; +Cc: pgsql-sql
On Tue, 04 Dec 2001 22:31:21 GMT
"Aasmund Midttun Godal" <postgresql@envisity.com> wrote:
> Well if you have spelled view "wiew" - that may be part of your problem,
>
> sincerely,
>
> Aasmund.
> On Tue, 4 Dec 2001 10:07:17 -0800 (PST), Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
> > On Tue, 4 Dec 2001, Manuel Trujillo wrote:
> >
> >
> > I'm probably missing something obvious, but
> > in any case the schema for tables and views
> > involved (preferably in create statements),
> > your PostgresQL version and the actual error
> > message you're getting would help us.
> >
> Aasmund Midttun Godal
>
> aasmund@godal.com - http://www.godal.com/
> +47 40 45 20 46
>
I would think his problem is caused by how to use aliases, at least,
D is apparently unnecessary. Since I don't know the definitions of his
tables, I can't affirm what type of an error happened. But if his tables
are correctly defined, his error is probably:
ERROR: Column reference "***" is ambiguous.
If so, the vague columns reference of his query ought to be adjusted
with explicitly using aliases: B, C, and E (e.g. see below).
select E.gallery_id, E.multimedia_id
from view_multimedia_file A
inner join (select B.gallery_id,
B.multimedia_id,
B.element_type_id,
C.result_type_id,
C.subevent_id,
C.subevent_type_id,
C.event_id,
C.championship_id,
C.championship_type_id,
C.season_id,
C.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)
) E
on (A.mm_id = E.multimedia_id)
;
Regards,
Masaru Sugawara
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2001-12-05 15:16 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-12-04 11:10 problems with this wiew Manuel Trujillo <manueltrujillo@dorna.es>
2001-12-04 18:07 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-12-04 22:31 ` Aasmund Midttun Godal <postgresql@envisity.com>
2001-12-05 15:07 ` Masaru Sugawara <rk73@echna.ne.jp>
2001-12-05 15:16 ` Masaru Sugawara <rk73@echna.ne.jp>
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