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

sql.json helper is missing in the docs #342

Closed
paulovieira opened this issue May 1, 2022 · 4 comments
Closed

sql.json helper is missing in the docs #342

paulovieira opened this issue May 1, 2022 · 4 comments

Comments

@paulovieira
Copy link
Contributor

It seems this helper was documented before, according to old issues like this: #114

But it's not anymore. Was it on purpose?

@porsager
Copy link
Owner

porsager commented May 2, 2022

Yeah, since v3 gets parameter descriptions from the db it's not needed anymore 😊

v1:

select ${ aJsObject }::jsonb
// doesn't work: returns [object Object]

v3

select ${ aJsObject }::jsonb
// works: returns parsed js object

@porsager porsager closed this as completed May 2, 2022
@paulovieira
Copy link
Contributor Author

paulovieira commented May 2, 2022

When I created the issue I had in mind insert and update queries. I was predicting some problems with more complex queries, such as those involving jsonb_set or the @> operator.

But meanwhile I have done some tests and found no problems at all! The bridge between javascript objects and json/jsonb in the postgresql database is perfect.

Wonderful work! Thank you.

@porsager
Copy link
Owner

porsager commented May 2, 2022

Very happy to hear 😊 Thank you for the kind words

@tmewett
Copy link

tmewett commented Nov 21, 2022

Is there a case for documenting it, due to #386 ?

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

3 participants