Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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@xxxxxxxxx> wrote:
On Apr 10, 2012, at 1:52, <mika@xxxxxxxxxxxxxx> 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.


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux