【openGauss/PostgreSQL】openGauss或PostgreSQL造数

---

【openGauss/PostgreSQL】openGauss或PostgreSQL造数

/* openGauss或PostgreSQL造数 */
with aa as (
-- 随机1万条 字符串 tzq 或 abc
  select generate_series(1,10000) as xh
          ,arr[ceil(random()*2)] as tzq_string
    from (select ARRAY['tzq','abc'] as arr) 
   order by 1 asc)
, bb as (
-- 随机1万条 日期 从 2024-07-17 到 2024-08-17
  select generate_series(1,10000) as xh
        ,arr[ceil(random()*32)] as tzq_date
    from (select array(SELECT generate_series('2024-07-17'::timestamp(0)
                                             ,'2024-08-17'::timestamp(0)
                                             , interval '1 DAY')) as arr) 
   order by 1 asc)
, cc as (
-- 随机1万条 100-10000 的数字
  select generate_series(1,10000) as xh,
         (floor(random() * (10000 - 100 + 1) + 100)::int) as tzq_amount)
, dd as (
-- 随机1万条 编码
select generate_series(1,10000) as xh,
       'LOG20240717'|| lpad(generate_series(10000001,10010000)::varchar,8,'0') as log_number)
select aa.xh
      ,aa.tzq_string
      ,bb.tzq_date
      ,cc.tzq_amount
      ,dd.log_number
  from aa,bb,cc,dd
 where aa.xh = bb.xh
   and aa.xh = cc.xh
   and aa.xh = dd.xh;