| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | emils(dot)klotins(at)gmail(dot)com |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Outer joins? |
| Date: | 2006-04-28 15:31:10 |
| Message-ID: | 1267.1146238270@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Emils <gnudiff(at)gmail(dot)com> writes:
> The table structure is:
> object_values
> ==========
> obj_id
> att_id
> value
> namely, each object can have arbitrary number of attributes each of
> them with a value.
> What I want, is a simple table of objects with some of their specific
> attributes, the result should be in form:
> obj_id1 o1att1_value o1att2_value o1att3_value
> obj_id2 o2att1_value o2att2_value o2att3_value
> ...
This isn't an outer-join problem, it's a crosstab problem. Try the
crosstab functions in contrib/tablefunc.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guy Fraser | 2006-04-28 15:52:31 | Re: LinkedList |
| Previous Message | Ross Johnson | 2006-04-28 15:24:45 | Re: set return function is returning a single record, |