Matt - You are correct and I was wrong - I had never seen that. Set it and retesting...
-Andrew On Mon, May 22, 2023 at 3:27 PM Matt Casters <[email protected]> wrote: > 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 <[email protected]>: > >> 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 < >> [email protected]> wrote: >> >>> Did you enable boolean support in the relational database connection? >>> >>> >>> >>> Op ma 22 mei 2023 20:04 schreef Galewsky, Andrew <[email protected]>: >>> >>>> 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 >>>> >>>
