Aha !!! Thanks Jim, the "trick" worked for me ! Regards. Milen
-----Original Message----- From: Jim C. Nasby [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 1:09 AM To: Tom Lane Cc: Milen Kulev; pgsql-general@postgresql.org Subject: Re: [GENERAL] Partitioning... On Mon, Jun 12, 2006 at 06:58:06PM -0400, Tom Lane wrote: > "Milen Kulev" <[EMAIL PROTECTED]> writes: > > What is wrong with random() ? > > Not guaranteed to be stable across the multiple evaluations that the > rule will perform ... remember a rule is a macro and has the usual > multiple-evaluation gotchas in the face of volatile arguments. I believe a safe alternative would be... INSERT INTO ... SELECT * FROM (SELECT random()*20 FROM ...) ; You might need to add an ORDER BY to the subquery to ensure PostgreSQL doesn't pull it into the main query. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
