Обсуждение: outer join not supported?
Hi, I'm trying to do a LEFT JOIN and I'm getting an error telling me that it's not supported. The log looks something like this: Mar 1 16:36:25 mars logger: StartTransactionCommand Mar 1 16:36:25 mars logger: query: SELECT t1.a1, t2.b Mar 1 16:36:25 mars logger: ^IFROM t1 LEFT JOIN t2 Mar 1 16:36:25 mars logger: ^ION t1.a1 = t2.a2 Mar 1 16:36:25 mars logger: ^IORDER BY t1.a1 Mar 1 16:36:25 mars logger: ERROR: OUTER JOIN is not yet supported Mar 1 16:36:25 mars logger: AbortCurrentTransaction I'm running PostgreSQL 7.0.3. There's nothing in the release docs saying that there's no outer join support, so I'm wondering if I need to reconfigure or recompile something. Thanks in advance! -- Eugene Lee eugene@anime.net
On Thu, Mar 01, 2001 at 03:14:41PM -0800, Eugene Lee wrote: > Hi, I'm trying to do a LEFT JOIN and I'm getting an error telling me > that it's not supported. The log looks something like this: [...] > I'm running PostgreSQL 7.0.3. There's nothing in the release docs > saying that there's no outer join support, so I'm wondering if I need > to reconfigure or recompile something. Thanks in advance! It's supported in 7.1, or you can check the FAQ for a workaround. HTH, Neil -- Neil Conway <neilconway@home.com> Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc Encrypted mail welcomed Vegetarians do not love animals... they hate plants.
On Thu, Mar 01, 2001 at 06:19:12PM -0500, Neil Conway wrote: : : On Thu, Mar 01, 2001 at 03:14:41PM -0800, Eugene Lee wrote: : > Hi, I'm trying to do a LEFT JOIN and I'm getting an error telling me : > that it's not supported. The log looks something like this: : [...] : > I'm running PostgreSQL 7.0.3. There's nothing in the release docs : > saying that there's no outer join support, so I'm wondering if I need : > to reconfigure or recompile something. Thanks in advance! : : It's supported in 7.1, or you can check the FAQ for a workaround. Ahhh, thanks for the quick response. It looks like 7.1 is still in development. And I'm just surprised that outer join support has been included in PostgreSQL until now! From my old database classes many years ago, outer joins were treated as a standard part of SQL. -- Eugene Lee eugene@anime.net