PostgreSQL Crosstab Example

Here is a bit of usage and demonstration description for the PostgreSQL Crosstab Query I put together in pursuit of something else completely…
Continue reading PostgreSQL Crosstab Example…

Microsoft Access and PostgreSQL Interaction

Microsoft Access does not handle boolean values in a default-compatible fashion with a PostgreSQL backend. Several errors will occur, but are solved via the addition of both of the necessary operator= and operator<> functions to manage the conversion, plus properly configuring the ODBC connection.

Continue reading Microsoft Access and PostgreSQL Interaction…