On Mon, 2008-01-21 at 22:05 +0200, Andrei Kovalevski wrote: > How can you garantee that "somevalue + random()" won't duplicate other > unique values in this column? ;) Like the inane memo from the boss says, "expect the unexpected" and "tell me all the unpredictable issues that will happen". If uid is unique then something like => select uid,somevalue,somevalue||'-'||uid from mytable is much better. -Reece -- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
