2010/1/27 Pierre Chevalier <pierre.chevalier1967@xxxxxxx>: > Hello, > > Some time ago, it was written here: >> >> ... >> I think there should be a generic way in Postgres to return from an EAV >> model. Although I have no evidence on that I keep thinking that the db must >> be more effective at that than the application would be. >> ... >> >> Yes, thanks. >> The problem with those function is that they all have an AS (columname >> type,...) part or equivalent. > > > SWK, I fully understand your needs, and your (our) kind of frustration... > > I am in a similar situation, with an EAV table, and the need to do crosstab > queries, without knowing in advance which columns the query should return, > and how many columns. > This is for chemical analysis results; laboratories store their results in > an EAV way, and it is definitely a good choice, for a large number of > reasons. > > On your side, have you found a decent solution? > Has anyone got an answer? > > I am just about to try this one: > http://www.ledscripts.com/tech/article/view/5.html > <http://www.ledscripts.com/tech/article/view/5.ht=> > > But I don't like this style too much: the crosstab approach seems more > "natural" to me. I may be totally wrong. > > So if there is a crosstab thing working in a generic way, that would be just > super! you cannot get crosstab via SELECT statement. There is workaround http://okbob.blogspot.com/2008/08/using-cursors-for-generating-cross.html Pavel > > A+ > Pierre > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
