Re: PostgreSQL money type

2015-06-08 Thread Oleg Oleynik
Yes, it works for me. Here are my code for PostgreSQL money type binding: database nameorg.jooq.util.postgres.PostgresDatabase/name includes.*/includes inputSchemapublic/inputSchema customTypes customType namePgMoney/name

Re: PostgreSQL EXTRACT

2015-06-08 Thread Oleg Oleynik
12:21 GMT+02:00 Oleg Oleynik oleg.ol...@gmail.com javascript:: Hi All! In PostgreSQL I can extract from TIMESTAMP in many ways: century, day, decade, dow, doy, epoch, hour, isodow, isoyear, microseconds, millennium, milliseconds, minute, month, quarter, second, timezone, timezone_hour

PostgreSQL 9.5 features

2015-07-14 Thread Oleg Oleynik
Hi all! I've just tried new PostgreSQL 9.5 alpha 1 with its great features like row-level security, insert...on conflict do nothing/update an so on. When JOOQ will have full support of that stuff? Next 3.7 realease or maybe later? What I can do if I want to help JOOQ with developing that

Re: PostgreSQL 9.5 features

2015-07-14 Thread Oleg Oleynik
. For instance, did you think about how jOOQ could add support for PostgreSQL's row-level security feature? Cheers, Lukas 2015-07-14 9:59 GMT+02:00 Oleg Oleynik oleg.ol...@gmail.com javascript: : Hi all! I've just tried new PostgreSQL 9.5 alpha 1 with its great features like row-level security

PostgreSQL money type

2015-06-04 Thread oleg . oleynik . 91
Hi all! I'm trying to learn JOOQ and I get some strange behavior with PostgesSQL money type. JOOQ codegen generates BigDecimal field in class for money field in DB. But when I try to select and use that field in WHERE clause, there are exception. Here are table definition: CREATE TABLE user (