[QGIS-trac] [Quantum GIS] #1789: PostGIS query: put '' around field values when appropriate

Quantum GIS qgis at qgis.org
Sat Jul 18 12:10:05 EDT 2009


#1789: PostGIS query: put '' around field values when appropriate
--------------------------------+-------------------------------------------
   Reporter:  pcav              |              Owner:  nobody       
       Type:  bug               |             Status:  new          
   Priority:  minor: annoyance  |          Milestone:  Version 1.2.0
  Component:  Data Provider     |            Version:  HEAD         
   Keywords:                    |   Platform_version:               
   Platform:  All               |           Must_fix:  No           
Status_info:  0                 |  
--------------------------------+-------------------------------------------
 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'

-- 
Ticket URL: <https://trac.osgeo.org/qgis/ticket/1789>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats


More information about the QGIS-trac mailing list