zio-sql icon indicating copy to clipboard operation
zio-sql copied to clipboard
verified publisher icon zio

Add 'justify_*' functions to PostgresModule

Open jczuchnowski opened this issue 5 years ago • 4 comments

Add support for functions justify_days, justify_hours and justify_interval described in the PostgreSQL docs.

  1. Add function to PostgresFunctionDef in PostgresModule
  2. Add test in FunctionDefSpec

jczuchnowski avatar Nov 15 '20 18:11 jczuchnowski

I want to give it a try

bonczek avatar Nov 21 '20 22:11 bonczek

I'm not sure how to handle postgres interval type. I noticed that someone already started to introduce 'interval' here: https://github.com/zio/zio-sql/pull/295/files I'll wait for that, because I don't want to double the work here.

bonczek avatar Nov 22 '20 10:11 bonczek

@jczuchnowski can you guide me a little? I don't know if the approach in linked PR is a good option. Should I implement reading of PGInterval type? I saw that there is a option to add dialect specific types, but I'm not sure how to use that.

bonczek avatar Nov 24 '20 20:11 bonczek

This is still an open issue.

jczuchnowski avatar Feb 20 '22 22:02 jczuchnowski