New data types for PostgreSQL 8.3

[Kless]

PostgreSQL 8.3 has any new data types very interesting as enumerated
(ENUM) [1], XML [2], Universally Unique Identifiers (UUID) [3].
Another interesting data type would be the monetary type [4].

It would very interesting that could be used from SQLAlchemy.


[1] http://www.postgresql.org/docs/8.3/static/datatype-enum.html
[2] http://www.postgresql.org/docs/8.3/static/datatype-xml.html
[3] http://www.postgresql.org/docs/8.3/static/datatype-uuid.html
[4] http://www.postgresql.org/docs/8.3/static/datatype-money.html

[Michael Hipp]

The "money" datatype is deprecated:
http://www.postgresql.org/docs/8.2/static/datatype-money.html

Not sure why that notice doesn't appear in the 8.3 docs.

Michael

[Michael Bayer]

they are easy enough to add and also easy for you to implement
yourself for the time being (read the section on "custom types" and/or
imitate an existing PG type from postgres.py). If you're interested,
that would make a patch for us to implement these new types.

[Kless]

It looks that it was undeprecated in 8.3

I question it on pgsl.general [1]. And looking for in the releases
notes it says:

"Widen the MONEY data type to 64 bits (D'Arcy Cain)

This greatly increases the range of supported MONEY values."


[1] http://groups.google.com/group/pgsql.general/browse_thread/thread/72621e5f7b62ba07
[2] http://developer.postgresql.org/pgdocs/postgres/release-8-3.html