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

Postgres Interval type #51

Open
keshov opened this issue Nov 10, 2016 · 1 comment
Open

Postgres Interval type #51

keshov opened this issue Nov 10, 2016 · 1 comment

Comments

@keshov
Copy link

keshov commented Nov 10, 2016

I'm using this module in couple with ngx_rds_json.
One of my table contains field with type 'interval'. When I want to build json page with simple select result of this table, I receive a broken json content.

It's because I have something like that inside a response:
... ,"postpone":00:00:02, ...

You treat postgres interval type as float for RDS.
src/resty_dbd_stream.h: rds_col_type_interval = 10 | rds_rough_col_type_float,

I am not familiar with RDS at all. May be in its conception it's all right, but not sure...
May be change rds_rough_col_type_float with rds_rough_col_type_str?
For me it solved the problem but I'm not sure that this is correct.

@agentzh
Copy link
Contributor

agentzh commented Nov 10, 2016

@keshov I'm not sure about that. You're encouraged to do the investigation and experiment on your side :) Thanks!

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