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

PostGIS query: put '' around field values when appropriate #11849

Closed
qgib opened this issue Jul 18, 2009 · 4 comments
Closed

PostGIS query: put '' around field values when appropriate #11849

qgib opened this issue Jul 18, 2009 · 4 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers
Milestone

Comments

@qgib
Copy link
Contributor

qgib commented Jul 18, 2009

Author Name: Paolo Cavallini (@pcav)
Original Redmine Issue: 1789

Redmine category:data_provider
Assignee: nobody -


When using the query builder from [[PostGIS]] provider, if the user selects a boolean, date, time etc. field that requires to be surrounded by _, they are written without them, so the query fails, eg:

fieldname=t

(where fieldname is a boolean, true/false) instead of

fieldname='t'

@qgib
Copy link
Contributor Author

qgib commented Jul 18, 2009

Author Name: Jürgen Fischer (@jef-n)


fixed in bcf09ab (SVN r11106)


  • resolution was changed from to fixed
  • status_id was changed from Open to Closed

@qgib
Copy link
Contributor Author

qgib commented Jul 18, 2009

Author Name: Paolo Cavallini (@pcav)


Fixed for boolean, not for date and time (possibily also other types)

@qgib
Copy link
Contributor Author

qgib commented Jul 18, 2009

Author Name: Paolo Cavallini (@pcav)


  • status_id was changed from Closed to Feedback
  • resolution was changed from fixed to

@qgib
Copy link
Contributor Author

qgib commented Jul 18, 2009

Author Name: Jürgen Fischer (@jef-n)


fixed in 69841f7 (SVN r11107)


  • resolution was changed from to fixed
  • status_id was changed from Feedback to Closed

@qgib qgib added Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers labels May 24, 2019
@qgib qgib added this to the Version 1.2.0 milestone May 24, 2019
@qgib qgib closed this as completed May 24, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Data Provider Related to specific vector, raster or mesh data providers
Projects
None yet
Development

No branches or pull requests

1 participant