Opened 15 years ago

Closed 15 years ago

#1789 closed bug (fixed)

PostGIS query: put '' around field values when appropriate

Reported by: pcav Owned by: nobody
Priority: minor: annoyance Milestone: Version 1.2.0
Component: Data Provider Version: Trunk
Keywords: Cc:
Must Fix for Release: No Platform: All
Platform Version: Awaiting user input: no

Description

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'

Change History (4)

comment:1 by jef, 15 years ago

Resolution: fixed
Status: newclosed

fixed in r11105

comment:2 by pcav, 15 years ago

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

comment:3 by pcav, 15 years ago

Resolution: fixed
Status: closedreopened

comment:4 by jef, 15 years ago

Resolution: fixed
Status: reopenedclosed

fixed in r11106

Note: See TracTickets for help on using tickets.