Hi there,
i'm using ZPyGreSQL successfully for my database. To keep it simple i
don't want to use MySQL for ZBabel.
ZBabel though uses some MySQL specific syntax which i am unsuccessfully
translating to PostgreSQL syntax:
Description "md5Hash" are the same fore entries with different "lang"
similar by using unions.
hth
Phil
[EMAIL PROTECTED]
- Original Message -
From: "Olaf Zanger" [EMAIL PROTECTED]
To: "Zope Mailinglist" [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, January 04, 2001 9:50 AM
Subject: [Zope] ZBabel translation to Postgres
H
hi andrew,
thanks for the description. i figured it as far as that:
you need in postgresql (this is tested only from zope with zsql method,
since some other things don't work in the ZBabel Produkt with
postgresql):
sqlGetPhrasesToUpdate:
select distinct Phrases.*
WHERE md5Hash not in
(
hi Phil,
The left join is a notation that says to get all records from the left hand
side of the join and only those records where the criteria matches from the
right hand side.
It is btw a part of most RDBMS engines I've ever used, so it's not that
unusual a syntax.
You can also do