pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gerhard Dieringer <DieringG@eba-haus.de>
To: craig.may@s2.enthdimension.com.au
Cc: pgsql-sql@postgresql.org
Subject: Antw: Join
Date: Thu, 07 Sep 2000 16:25:51 +0200
Message-ID: <s9b7c1a6.002@kopo001> (raw)

>>> Craig May <craig.may@s2.enthdimension.com.au> 08.09.2000  02.59 Uhr >>>
> Hi,

> I'm having trouble with this statement, could someone help out please.

> Select g.ID From Grouping g join Entity_Grouping eg on g.ID=eg.Group_ID where
> eg.Entity_ID=1

> The error message is:

> ERROR: transfromExpr: does not know hot to transfrom node 501 (internal error)

> Craig May


> Enth Dimension
> http://www.enthdimension.com.au/ 

It's a bug in 7.0.0. You can update to 7.0.2 or use the non-ANSI-join-syntax:

Select g.ID From Grouping g, Entity_Grouping eg 
WHERE g.ID=eg.Group_ID AND eg.Entity_ID=1

Gerhard





Message-ID: <s9b7c1a6.002@kopo001>
Permalink:  ../s9b7c1a6.002@kopo001/
Also on:    postgresql.org/message-id/s9b7c1a6.002@kopo001

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: DieringG@eba-haus.de, craig.may@s2.enthdimension.com.au
  Subject: Re: Join
  In-Reply-To: <s9b7c1a6.002@kopo001>
  References: <s9b7c1a6.002@kopo001>

* 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