[Zope] Re: ZBabel translation to Postgres

[Albert Langer]

The following references from search of huge numbers for "left join" at
www.postgresql.org may be helpful:

http://www.postgresql.org/mhonarc/pgsql-sql/2000-03/msg00023.html

http://www.postgresql.org/mhonarc/pgsql-hackers/2000-12/msg00634.html

http://www.postgresql.org/mhonarc/pgsql-hackers/2000-12/msg00656.html

http://www.postgresql.org/mhonarc/pgsql-general/2000-12/msg00194.html

Summary:

1) Easy to work around
2) There was a bug
3) It's been fixed
4) Comprehensive implementation in 7.1(devel)

Many more messages not looked at so above summary may be wrong

-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of
Andrew Kenneth Milton
Sent: Thursday, January 04, 2001 9:59 PM
To: Olaf Zanger
Cc: Zope Mailinglist; akm@theinternet.com.au
Subject: [Zope] Re: ZBabel translation to Postgres


+-------[ Olaf Zanger ]----------------------
| Hi there,

...

| What does the whole thing do anyway?

Finds all the phrases that don't have a translation for the language
selected. It's hard to find things that don't exist in databases without
nested selects which MySQL did not have at the time.

MySQL was chosen precisely because it is restricted, and is basically the
lowest common denominator when it comes to SQL.

I do recall however, that postgres only implements INNER and OUTER joins
although I don't know the status of the JOIN stuff in postgres at this time.

| Has anybody ported ZBabel already?

Someone was going to send me patches for postgres, but, I never received
them.

I'll happily integrate patches, although, automatically selecting the
right query based on database type will be required so that several releases
aren't required. I don't think that that's a hard thing to achieve.

--
Totally Holistic Enterprises Internet|  P:+61 7 3870 0066   | Andrew Milton
The Internet (Aust) Pty Ltd          |  F:+61 7 3870 4477   |
ACN: 082 081 472 ABN: 83 082 081 472 |  M:+61 416 022 411   | Carpe Daemon
PO Box 837 Indooroopilly QLD 4068    |akm@theinternet.com.au|

_______________________________________________
Zope maillist  -  Zope@zope.org
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )