On Fri, Jun 22, 2012 at 01:16:02PM +0200, Petr Jake?? <[email protected]> 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/ [email protected]
Programmers don't die, they just GOSUB without RETURN.
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
