Hi,
I have an embedded application retrieving data from a postgres database using the ECPG client interface. One process acts as an intermediary for other tasks for r/w operations.
When the the pg interface task retrieves a row into a sql descriptor and inspects the column types for a declared Boolean field, The Client is given a string type with data value of ‘t’/’f’. Why is it (ECPGt_char) rather then ECPGt_bool ?
Very human friendly but I have a machine making decisions.
If I pass this column/data along as strings the other tasks are left to do less efficient comparisons to ‘t’ or ‘f’ to asses a flag.
I suppose I could declare it an int column with a range of 1 or 0.
Is there anything more elegant ?
I am new to database programming and postgres.
( Any good postgres programming best practice guides out there ? )
Tnx
Dave