Re: ViewSQLObject ID's
Oleg Broytman <[email protected]>
| Newsgroups | gmane.comp.python.sqlobject |
|---|---|
| Message-ID | <[email protected]> |
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/