Hi Ben, 2014-04-16 12:19 GMT+02:00 Ben Hood <[email protected]>:
> Hey Lukas, > > Thanks for that pointer - do you have an example of how to use it? > The manual is a bit scarce in that area: http://www.jooq.org/doc/latest/manual/sql-building/table-expressions/pivot-tables/ We don't have an example using jOOQ for pivot. But usage shoul dbe straight-forward. Except that the FOR keyword was replaced by ON (because "for" is a reserved word in Java) > On a related tangent, I was wondering (under the assumption that the > dataset is small enough) whether I could run an instance of XE instead > of Postgres.... > Yes, with Oracle XE, you could solve this directly using native PIVOT support. I suspect that this will be faster than actually emulating PIVOT. -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
