Re: select unnest(col) from t

2017-02-16 Thread Lukas Eder
Hi Max, Thanks for your message. Indeed, it would be handy - I don't deny that at all. The problem with jOOQ's current API is that we cannot implement this without breaking the API. Or, we could use a dummy name instead of unnest - so we don't have to touch the existing API. The existing API reads

Literal values

2017-02-16 Thread Hilco Wijbenga
Hi all, We are using jOOQ 3.6.4 because that is the most recent version that does not require JDK 1.8. I ran into a strange problem yesterday when a jOOQ query did not work. I boiled it down to the following: dslContext .select(DSL.val(Integer.valueOf(1))) .getQue

Re: select unnest(col) from t

2017-02-16 Thread Max Kremer
Yes I hear you, probably not worth it then. You are right we are only using unset on a single column. The use case is the common "tags" field where you have an array of tags on a record. On Thursday, February 16, 2017 at 7:38:54 AM UTC-5, Lukas Eder wrote: > > Hi Max, > > Thanks for your message

Re: Literal values

2017-02-16 Thread Hilco Wijbenga
On 16 February 2017 at 09:15, Hilco Wijbenga wrote: > We are using jOOQ 3.6.4 because that is the most recent version that > does not require JDK 1.8. > > I ran into a strange problem yesterday when a jOOQ query did not work. > I boiled it down to the following: > > dslContext > .s