On Fri, 22 Jun 2001, Justin Clift wrote: > i.e. CREATE SEQUENCE newseq INCREMENT trunc(random() * 10); Didn't you ask this like 2 weeks ago? I said it once, I'll say it again. Stop being lazy, and write a trigger. The Postgres developers are *not* going to alter the core functionality of their database to include something that has always been available. http://www.postgresql.org/idocs/index.php?triggers.html Read it, use it, love it. -- +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+ | Shaun M. Thomas INN Database Programmer | | Phone: (309) 743-0812 Fax : (309) 743-0830 | | Email: [EMAIL PROTECTED] AIM : trifthen | | Web : hamster.lee.net | | | | "Most of our lives are about proving something, either to | | ourselves or to someone else." | | -- Anonymous | +-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-+ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]