| From: | "Gerhard Dieringer" <DieringG(at)eba-haus(dot)de> |
|---|---|
| To: | <craig(dot)may(at)s2(dot)enthdimension(dot)com(dot)au> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Antw: Join |
| Date: | 2000-09-07 14:25:51 |
| Message-ID: | s9b7c1a6.002@kopo001 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
>>> Craig May <craig(dot)may(at)s2(dot)enthdimension(dot)com(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ingram, Bryan | 2000-09-07 15:15:02 | Foresee any problems with this? postgres-failover (long) |
| Previous Message | Kristofer Munn | 2000-09-07 14:03:26 | Re: Join |