Re: Is this doable using Postgresql crosstab or some other function?

 This schema is in use in one quite big system, which utilizes different
 DB than Postgresql.
 It is fully functional.

 - mika -


 On Tue, 10 Apr 2012 02:19:14 -0700, David Johnston <polobo@yahoo.com>
 wrote:
> On Apr 10, 2012, at 1:52, <mika@digikartta.net> wrote:
>
>>
>> Quite challanging, right?
>>
>
> Aside from the possibly extremely rare case where this is actually
> functional the only challenging task is to tell off whomever gave you
> the idea/requirement that your schema is desirable - even if that
> person is yourself.
>
> That aside, judicious use of CASE constructs, and probably UNION,
> will get you your answers.  Keep in mind that you likely need to end
> up casting all of your values to varchar/text in the end.
>
> You may also want to look at the HSTORE extension.
>
> Given the generic nature of your inquiry actual specific advice is
> impossible to give.
>
> David J.