[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