[Tagging] Fast Food Restaurants
Richard Welty
rwelty at averillpark.net
Thu May 30 01:38:08 UTC 2013
On 5/29/13 6:42 PM, Richard Welty wrote:
> On 5/29/13 6:01 PM, Tac Tacelosky wrote:
>> I see "amenity:Restaurant" and "amenity:restaurant" are both returned
>> from the api. And I just discovered that postgres does case-sensitive
>> LIKE's. Sigh.
> now fixing this is actually a reasonable thing to do in a bulk edit,
> because many data consumers likely don't do case flattening and
> will miss Restaurant
and i'll also point out that postgresql has useful string functions like
LOWER that can be applied to arguments before using LIKE if you really
feel the need to bandaid around case errors in tag values
richard
More information about the Tagging
mailing list