| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | Erik Jones <erik(at)myemma(dot)com> |
| Cc: | Klein Balazs <Balazs(dot)Klein(at)t-online(dot)hu>, 'Tino Wildenhain' <tino(at)wildenhain(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: dynamic crosstab |
| Date: | 2008-02-15 02:19:06 |
| Message-ID: | 47B4F69A.7050609@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Erik Jones wrote:
> See how postgres handles filling the NULLs for you? What you'd really
> want to do with this would be to define some functions for setting and
> getting a person's answers to a given question or set of questions so
> that you could implement some kind of data integrity with regards to
> question ids and indices into the answers arrays such as in the example
> above you'd want to prevent an entry at index 7 when there is no entry
> in the questions table for question_id=7.
It occurs to me that it shouldn't be terribly difficult to make an
alternate version of crosstab() that returns an array rather than tuples
(back when crosstab() was first written, Postgres didn't support NULL
array elements). Is this worth considering for 8.4?
Joe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | william | 2008-02-15 03:39:53 | the feasibility of sending email from stored procedure in Postgres |
| Previous Message | Douglas McNaught | 2008-02-15 00:58:29 | Re: PG quitting sporadically!! |