Today if been trying to get the Sales Demo application to work with Postgresql 13.6.

The on the Github suggested database didn't restore (reported as a bug and will be fixed).

After being pointed to another working version of the database by Mark Lee ( 

https://github.com/Appeon/PowerBuilder-Project-Example-Database ), when running the app and clicking on the Order button I'm getting errors.

- When opening some datawindows, for none of them it seems to be possible to convert the datasource to 'graphics mode' the simplest select fails to convert.

And then there is this Select that fails in any mode, giving me an error

"

---------------------------
DataWindow
---------------------------
Database error:

SQLSTATE = 42883
ERROR: operator does not exist: boolean = integer;
No query has been executed with that handle
---------------------------
OK
---------------------------

": 

The problem seems to be the "FinishedGoodsFlag = 1", if I change the = 1 to be = true, it works:

SELECT
        Production.Product.Name                         ,
        Production.Product.ProductNumber                ,
        Production.Product.Color                        ,
        Production.Product.ListPrice                    ,
        Production.Product.Size                         ,
        Production.Product.ProductSubcategoryID         ,
        Production.Product.ProductModelID               ,
        Production.ProductCategory.Name                 ,
        Production.ProductSubcategory.ProductCategoryID ,
        Production.ProductSubcategory.Name              ,
        Production.ProductModel.Name                    ,
        Production.Product.ProductID
FROM
        Production.Product         ,
        Production.ProductCategory ,
        Production.ProductModel    ,
        Production.ProductSubcategory
WHERE
        (
                Production.ProductModel.ProductModelID = Production.Product.ProductModelID )
and     (
                Production.ProductSubcategory.ProductCategoryID = Production.ProductCategory.ProductCategoryID )
and     (
                Production.ProductSubcategory.ProductSubcategoryID = Production.Product.ProductSubcategoryID )
and     (
                ( Production.Product.FinishedGoodsFlag = 1 )
        and     (
                        Production.Product.ProductID in
                        (
                                SELECT
                                        Sales.SpecialOfferProduct.ProductID
                                FROM
                                        Sales.SpecialOfferProduct ) ) )
ORDER BY
        Production.Product.ProductID ASC

I've seen in the ODBC configuration that there's an option called "bools as char". I've tried to un-check it, but it doesn't make any difference.
Is there some kind of a DB parm I can set to avoid having to change all flags to boolean TRUE or FALSE?

TIA

MiguelL