Hello
Is there any way to concatenate strings inside results?
For example:
select * from flickr.photos.search where text in (select country + “ “ + city from location where….)
So (country + “ “ + city) is concatenating the field country and field city with a space.
Thanks
Not currently.
However, joining data based on location can be done very nicely through the use of "woeids" (where on earth ids) that many tables expose as key fields and the geo service produces quite easily:
So to get photos in flickr taken around "san francisco" I could do this:
select * from flickr.photos.search where woe_id in (select woeid from geo.places where text="san francisco")
The geoplanet servics, made available through the various geo tables, accept many different forms of querying, so you can get a broad match or a very precise one.
Jonathan
