Hello folks,

I have a table that contains a INET column:

CREATE TABLE backend_registration (
  id                 BIGSERIAL                   NOT NULL PRIMARY KEY,
  password_hash      TEXT                        NOT NULL,
  confirmation_token TEXT,
  created_at         TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now(),
  created_ip         INET);

However I can't get how to insert an address into column 'created_ip'

factory.insertInto(REGISTRATION)
.set(REGISTRATION.EMAIL, "[email protected]")
.set(REGISTRATION.PASSWORD_HASH, "2304820984309238409237428739")
.set(REGISTRATION.CREATED_IP, "::1")
.execute();

^ this does not work and I get the following error:

>> ERROR: column "created_ip" is of type inet but expression is of type 
character varying
>>  Hint: You will need to rewrite or cast the expression.

Is there a way to solve this issues?

Should type INET be supported by jooq natively?

Cheers
Peter

Reply via email to