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 >> >