[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: FW: [Phpgroupware-users] ``flat'' addressbook table...
From: |
Marco Gaiarin |
Subject: |
Re: FW: [Phpgroupware-users] ``flat'' addressbook table... |
Date: |
Mon, 14 Jun 2004 12:04:04 +0200 |
User-agent: |
Mutt/1.5.5.1+cvs20040105i |
Mandi! Chris Weiss
In chel di` si favelave...
> what about make a database view? assuming you're using a database that
> supprts such a thing...
Oh, good idea, i'm using postgres so views are supported... but is not
viable, at least for my SQL/PG knowledge...
I can make some correlation (join) between people and addresses, but
when i try to join the comm infos, they are organized very different
for a flat table, so i can extract only one information (eg, the work
fax) for addresses.
Better was if i can extract more, at least voice phone and fax, on the
same row...
--
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bontà , 7 - 33078 - San Vito al Tagliamento (PN)
gaio(at)sv.lnf.it tel +39-0434-842711 fax +39-0434-842797
... votantoniovotantoniovotantoniovotantoniovotantoniovotantonio ...
resistenza arcobaleno contro la politica grigia
http://www.peacelink.it/votantonio