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"
fields. They are used to translate depending on selected language.

SELECT 
Phrases.* 

FROM 
Phrases 

LEFT JOIN 
Phrases as b 

ON 
Phrases.md5Hash = b.md5Hash AND Phrases.lang <> b.lang

WHERE 
b.md5Hash is NULL AND Phrases.lang=<dtml-sqlvar srcLang type=nb>

What does the whole thing do anyway?
How can you join "Phrases.md5Hash = b.mdf5Hash", while "md5Hash is
NULL"?
What is different in the LEFT JOIN ... ON ... statement to a normal
WHERE clause?
My try for translation to PostgreSQL (which I assume is completely
ignorant):

SELECT 
Phrases.* 

FROM 
Phrases as b

WHERE 
Phrases.md5Hash *= b.md5Hash AND Phrases.lang <> b.lang AND

b.md5Hash is NULL AND Phrases.lang=<dtml-sqlvar srcLang type=nb>


Has anybody ported ZBabel already? 
Thanks for help

Olaf

-- 
soli-con Engineering Zanger
Dipl.-Ing. (FH) Olaf Marc Zanger
Lorrainestrasse 23
3013 Bern / Switzerland
Fon: +41-31-332 9782
Mob: +41-76-572 9782
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
http://www.soli-con.com
begin:vcard 
n:Zanger;Olaf Marc
tel;cell:+41-76-572 9782
tel;work:+41-31-332 9782
x-mozilla-html:FALSE
url:www.soli-con.com
org:soli-con Engineering Zanger
adr:;;Lorrainestrasse 23;Bern;BE;3013;Switzerland
version:2.1
email;internet:[EMAIL PROTECTED]
title:Dipl.-Ing.
note;quoted-printable:IT-Consulting=0D=0AEmbedded Systems=0D=0AEnergy Systems=0D=0AOpen Source Solutions=0D=0A
x-mozilla-cpt:;-32176
fn:Olaf Zanger
end:vcard

Reply via email to