#1 Updates to postgres library.

open
nobody
None
5
2006-01-13
2006-01-13
Mark Lee
No

This patch contains updates I've made whilst using
jungerl.

For select results, I've returned the column names so
select returns {ok, 'SELECT', ColumnNames, Result}.
This means I avoid the problem of recording column
names at query preparation time and as this
information is already present in the code but
discarded it seemed virtually no overhead to pass it
back with the results. This is the only API change in
the patch.

Handles updates and returns {ok, 'UPDATE', NRows}

Converts atoms to strings when passed in as parameters
if they're not 'null'.

Handles nulls in results sets.

Converts fixed character fields in result set to
strings.

Converts timestamp fields to datetime tuples.
NOTE: This will only work with integer timestamps as
my server's configured with these and I've not got
round to adding in code to check and handle floats but
should be trivial.

Discussion

  • Mark Lee
    Mark Lee
    2006-01-13

    pgsql patch file

     
    Attachments