ECPG and server datatypes vs client representations.

Started by Day, Davidalmost 15 years ago1 messagesgeneral
Jump to latest
#1Day, David
dday@redcom.com

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