Re: [GENERAL] Exception in Query when mixing explicit join and implicit

2005-09-01 Thread Sebastian Hennebrueder
Tom Lane schrieb: >Sebastian Hennebrueder <[EMAIL PROTECTED]> writes: > > >>-- the following query has a inner join and an implicit join and does >>not work. >>select a.name as act_name, >>u.name as trainer >>from >>activity a, >>localgroup lg, >>sponsor spon >>inner join tuser u on a.fk_trainer

Re: [GENERAL] Exception in Query when mixing explicit join and implicit join

2005-09-01 Thread Tom Lane
Sebastian Hennebrueder <[EMAIL PROTECTED]> writes: > -- the following query has a inner join and an implicit join and does > not work. > select a.name as act_name, > u.name as trainer > from > activity a, > localgroup lg, > sponsor spon > inner join tuser u on a.fk_trainer=u.id > where spon.name='J

[GENERAL] Exception in Query when mixing explicit join and implicit join

2005-09-01 Thread Sebastian Hennebrueder
Hallo, in an existing application I got an exception and tracked it down to a generated query from the Java OR mapping solution Hibernate Actually I was suprised that the query does not work and created a simple use case to explain the problem (see and of this email). The postgre SQL exception i