Opened 18 years ago
Closed 15 years ago
#2006 closed defect (fixed)
Join with postgis table
Reported by: | Owned by: | pramsey | |
---|---|---|---|
Priority: | high | Milestone: | |
Component: | PostGIS Interface | Version: | 4.10 |
Severity: | normal | Keywords: | |
Cc: |
Description (last modified by )
Join with postgis table noz work when FROM and TO items are charater type. mappostgresql.c line 336 must change to sprintf(sql, "SELECT %s FROM %s WHERE %s = '%s'", columns, join->table, join->to, joininfo->from_value); thanks
Change History (7)
comment:1 by , 18 years ago
Cc: | added |
---|---|
Component: | MapServer C Library → PostGIS Interface |
Owner: | changed from | to
comment:2 by , 18 years ago
Pretty sure we didn't do the postgresql joining. Putting in the ticks should actually work, postgresql is pretty clever about appropriately casting things.
comment:3 by , 18 years ago
Status: | new → assigned |
---|
Wonder who did? Anyway, cool, I'll make that change then and test it out. Steve
comment:4 by , 17 years ago
Description: | modified (diff) |
---|
Steve,
Are you still planning to fix this? If you are too busy, feel free to reassign it to me, and I'll take a crack at it.
comment:5 by , 17 years ago
Please take it if you have time. It should be easy enough to test. I don't have Postgres running on my mac but I could test at work if necessary.
Steve
comment:6 by , 16 years ago
Owner: | changed from | to
---|---|
Status: | assigned → new |
comment:7 by , 15 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.