From: | Mihamina Rakotomandimby <mihamina(at)gulfsat(dot)mg> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | describe relation between LDAP entries |
Date: | 2010-01-13 13:43:28 |
Message-ID: | 20100113164328.2cd96b70@pbmiha.malagasy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Manao ahoana, Hello, Bonjour,
I have LDAP entries, and SQL tables are the relation between them.
There are only relations between 2 entries.
There are "modem" and "customers" entries in the LDAP directory
I need advice on optimizing the way I store relations.
For example (This is on MySQL, just for the example)
SELECT * FROM customer_has_modem;
+-----------------+----------------+
| customer | modem |
+-----------------+----------------+
| a=aa,b=bb,c=ccc | d=dd,e=ee,f=ff |
+-----------------+----------------+
Is it OK?
Have you another way to do it?
- splitting the comma separated fields?
- whatever?
There might later be be a "date" field in this table to trace the modem
movements.
Misaotra, Thanks, Merci.
--
Architecte Informatique chez Blueline/Gulfsat:
Administration Systeme, Recherche & Developpement
+261 34 29 155 34 / +261 33 11 207 36
From | Date | Subject | |
---|---|---|---|
Next Message | Mihamina Rakotomandimby | 2010-01-13 13:52:03 | Re: describe relation between LDAP entries |
Previous Message | Claudio Eichenberger | 2010-01-13 13:03:54 | autovacuum_naptime seems to take minutes for seconds |