pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (5+ messages)  latest in thread

Message-ID: <20011204111047.GA10294@dorna.es>
Permalink:  ../20011204111047.GA10294@dorna.es/
Also on:    postgresql.org/message-id/20011204111047.GA10294@dorna.es

 · 

reply

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