I'm asking since the option is not enabled by default in the Hop Metadata element. Boolean is not a standard SQL datatype so Hop wants to know if you want to use it.
Op ma 22 mei 2023 21:20 schreef Galewsky, Andrew <a...@galewsky.net>: > As far as I know there is nothing specific about that in the connection > for postgresql.... > > -Andrew > > On Mon, May 22, 2023 at 1:39 PM Matt Casters < > matt.cast...@leanwithdata.com> wrote: > >> Did you enable boolean support in the relational database connection? >> >> >> >> Op ma 22 mei 2023 20:04 schreef Galewsky, Andrew <a...@galewsky.net>: >> >>> I have been fighting this since I started using hop. For example I >>> have a database field that is boolean but the incoming field has some dirty >>> data and is not able to be set as a bool in its temp table. It has to be a >>> varchar. As part of the pipeline the data gets cleaned up and is now >>> truly boolean. As far as I can tell now there is no way to cast it as bool >>> before writing to the output table. Am I dense or missing something?. >>> >>> -Andrew Galewsky >>> >>
