Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql

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",

Also consider that a person may not have data related to all possible

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,
Sao Paulo - SP - Brasil


pgsql-sql by date

Next:From: Stephan SzaboDate: 2000-08-24 18:45:19
Subject: Re: Question on string value expression wildcarding
Previous:From: Steve WamplerDate: 2000-08-24 18:15:42
Subject: Question on string value expression wildcarding

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group