Good morning ,
In retrieving a boolean value from a record set it always defaults to 0 . The Creo query as well as Postgres clients show t.
Console.write(rs.active); --> 0 .
I use SEQUEL for Postrgres to create tables/columns, in this case a boolean , For Creo there are 2 controls associated with boolean columns t/f, a toggle for active ( 0/false for non active, 1/true for active) and a 2 segment segmented control where 0 segment is for Male, 1 for female. When the records set is displayed from the Postgres1.Query1 the column row in question displays as 't', but somethings off when using select(sql) . All others column types do not seem to have an issue .
There is a delay as I switched providers ( have optic to the house now ) messed my IP with AWS so it will take a day or so to figure that out .