Re: [SQLObject] ViewSQLObject ID's

[Oleg B. <ph...@ph...>]

On Fri, Jun 22, 2012 at 01:16:02PM +0200, Petr Jake?? <pet...@tp...> wrote:
> >    SELECT CAST(t1.id as TEXT) + ':' + CAST(t2.id as TEXT) AS id, ...
> >
> >
> Just wondering what is delimiter helpful for? Just to recognize t1.id and
> t2.id later on?

   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.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.