weird structure

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-sql by date

  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