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

Support Postgres boolean values #469

Closed
gordon-matt opened this issue Apr 17, 2017 · 2 comments
Closed

Support Postgres boolean values #469

gordon-matt opened this issue Apr 17, 2017 · 2 comments
Labels
feature New feature
Milestone

Comments

@gordon-matt
Copy link

true and false values are being automatically converted to 1 and 0, respectively. This is suitable for MSSQL, but not for Postgres, which requires true/false, not 1/0. Is there an option in the query builder config for this? If not, please add this option.

@mistic100
Copy link
Owner

mistic100 commented Apr 17, 2017

In the next version you will be able to configure it globally in the plugins section :

$builder.queryBuilder({
  plugins: {
    'sql-support': { boolean_as_integer: false }
  }
});

@mistic100 mistic100 added the feature New feature label Apr 17, 2017
@mistic100 mistic100 added this to the 2.4.4 milestone Apr 17, 2017
@gordon-matt
Copy link
Author

I can confirm this solution is working. Thank you.

Repository owner deleted a comment from ilyagtangelogamescom Dec 28, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature New feature
Projects
None yet
Development

No branches or pull requests

2 participants