Walter Underwood [mailto:wun...@wunderwood.org] writes: >On Mar 5, 2012, at 1:16 PM, Welty, Richard wrote:
>> Walter Underwood [mailto:wun...@wunderwood.org] writes: >>> You may be able to have unique keys. At Netflix, I found that there were >>> collisions between the movie IDs and the person IDs. So, I put an 'm' at >>> the beginning of each movie ID and a 'p' at the beginning of each person >>> ID. Like magic, I had unique IDs. >> did you do this with a transformer at index time, or in some other manner? >SQL should be able to do this, though it might not be portable. For MySQL is > it something like: >select > concat('m', movie_id) as id, ok, thanks. i know how to do that in postgresql... richard
