Skip to content
This repository has been archived by the owner on Feb 11, 2023. It is now read-only.

Document how to interact with range types #45

Open
Thorn1089 opened this issue Nov 28, 2018 · 1 comment
Open

Document how to interact with range types #45

Thorn1089 opened this issue Nov 28, 2018 · 1 comment

Comments

@Thorn1089
Copy link

It's unclear if I can query range types or insert range values via the driver (either through 'normal' mechanisms like setObject or through extensions).

If it's impossible, a short blurb somewhere stating that you can't use range types via JDBC would also help clarify things for future searchers too.

@davecramer
Copy link
Member

@TomRK1089
Looking at the code we would have to implement a PGrange type in order to be useful.
So to answer your question; currently there is no built in facility to deal with range types through something like setObject. I imagine it should be possible to insert them directly using a insert statement such as INSERT INTO reservation VALUES (1108, '[2010-01-01 14:30, 2010-01-01 15:30]'); but not with parameters.

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

No branches or pull requests

2 participants