JuliaDatabases / PostgreSQL.jl

DEPRECATED: use LibPQ.jl instead
https://github.com/invenia/LibPQ.jl
Other
60 stars 39 forks source link

Handling citext and uuid as types #40

Open johannspies opened 8 years ago

johannspies commented 8 years ago

More a question or request than an issue:

How can I add citext and uuid as PostgreSQL-types handled by PostgreSQL.jl?

At the moment I have do casting in the query like this:

Select title::text from wos_2016_2.article where title = 'Mouse Clicks and Key StrOkes';

where title is of the type 'citext';

iamed2 commented 8 years ago

In https://github.com/JuliaDB/PostgreSQL.jl/blob/master/src/types.jl:

timestamp is a good example to follow.