Re: [SQLObject] ViewSQLObject ID's

[Hans G. S. <geo...@sc...>]

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