Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Handling citext and uuid as types #40

Open
johannspies opened this issue Jul 12, 2016 · 1 comment
Open

Handling citext and uuid as types #40

johannspies opened this issue Jul 12, 2016 · 1 comment

Comments

@johannspies
Copy link

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
Copy link
Contributor

iamed2 commented Jul 12, 2016

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

  • Make a newpgtype call (you have to know the OID for the type)
  • Define a jldata method
  • Define a pgdata method

timestamp is a good example to follow.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants