On Thu, 14 Oct 2004, Andrew Dunstan wrote: > >That makes sense. Allowing "rand" would be nice too. > > You can now - it's part of :base_math.
Oh, ok. I saw it's not included in :base_core despite being in :base_math, but didn't realize explicitly including :base_math would bring it back. > What we should do, however, is disallow is calling srand, since pg goes > to quite a bit of trouble to seed the PRNG. That sounds reasonable. Jon -- Jon Jensen End Point Corporation http://www.endpoint.com/ Software development with Interchange, Perl, PostgreSQL, Apache, Linux, ... ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
