On Fri, Jun 22, 2012 at 03:26:42PM +0400, Oleg Broytman wrote: > Yes. And to distinguish "1:11" and "11:1" - without a delimiter you > get two different rows with the same id; with pure integer id's of a > limited range that can be fixed in a different way: > > SELECT t1.id*1000000000 + t2.id, ... > > but the idea is the same.
In many ways, integers would be preferable, but using the string with a non-digit delimiter saves me the trouble of figuring out how large the constituent integers may be, and how large the aggregate integer would be allowed to become. In short, a quick and dirty solution to ensure uniqueness. -- :-- Hans Georg ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
