| From: | rdg(at)viafractal(dot)com(dot)br |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | rdg(at)viafractal(dot)com(dot)br |
| Subject: | weird structure |
| Date: | 2000-08-24 18:24:11 |
| Message-ID: | 200008241824.e7OIOR528066@hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
Consider the following tables/fields:
table "person": fields "p_id", "p_name".
table "person_attribute": fields "a_id", "a_name".
table "person_data": fields "d_person_id", "d_attribute_id",
"d_value".
Also consider that a person may not have data related to all possible
attributes.
Using this structure, how could I retrieve in one row with a single
select statement all attributes from a person (showing null to
attributes that were not registered to him)?
Thanks for any suggestion,
--
Renato
Sao Paulo - SP - Brasil
rdg(at)viafractal(dot)com(dot)br
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2000-08-24 18:45:19 | Re: Question on string value expression wildcarding |
| Previous Message | Steve Wampler | 2000-08-24 18:15:42 | Question on string value expression wildcarding |