Hi Bruce,
Thanks. I tried. It works.
Regards.
Grace
At 2012-05-03 07:14:21,"Bruce Momjian" <bruce@xxxxxxxxxx> wrote: >On Wed, May 02, 2012 at 11:03:47AM -0700, leaf_yxj wrote: >> Hi Andreas, >> >> Thanks a lot. >> >> I tried those following , they work. >> >> 1) insert into test values ( generate_series(1,100000000000), >> md5(random()::text)); >> >> >> 2) create table t_random as select s, md5(random()::text) from >> generate_Series(1,5) s; > >Here is a method that generates strings with a little more variability: > > SELECT > ( > SELECT string_agg(x, '') > FROM ( > SELECT chr(ascii('A') + (random() * 25)::integer) > -- reference 'b' so it is correlated and re-evaluated > FROM generate_series(1, 40 + b * 0) > ) AS y(x) > ) > FROM generate_series(1,5) as a(b); > > string_agg > ------------------------------------------ > JWNRUIEPJQGDVBXDJDTROFSNMKGVNAQWWEORMSHV > KNYGOWJXBEPOJICURIQGIIDFMRXYLFUUSTCIRLGR > PVHXEITVQKBZREFEVDDHHYCASEIKPOCFJJDNRWJJ > HKIYONDLQGSXFUXXZGHPUKUESXRLUATBLCAAPDLG > JEENYCLYISODDIGWGXHBYCCJECJTFUAOYECXGNWO > (5 rows) > >-- > Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + It's impossible for everything to be true. +
