Skip site navigation (1) Skip section navigation (2)

merry christmas folks

From: Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl>
To: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: merry christmas folks
Date: 2008-12-24 20:11:56
Message-ID: 4198844C-ABE9-4D29-88F3-CDDEEB726982@pointblue.com.pl (view raw or flat)
Thread:
Lists: pgsql-hackers
WITH RECURSIVE tree(b, l, lv) AS
  (
   (
    WITH RECURSIVE t(b, l) AS
     (
       select b/11.6, 0 AS l from (select  
generate_series(0,30)::float8 b union all select generate_series(30,0,  
-1)::float8 b) ziew
         UNION ALL
       select (b*1.06), l+1 FROM t WHERE l < 3
     )
     select b, l, 1 AS lv from t order by l asc
   )
   UNION ALL
    select b*1.1, l+(lv*62) AS l , lv+1 FROM tree WHERE lv < 4
  )
select array_to_string(array_agg(SUBSTRING('  ....',  
LEAST(GREATEST(b::integer,1),6), 1)),'') from tree group by l order by  
l asc;


;]



pgsql-hackers by date

Next:From: Bruce MomjianDate: 2008-12-24 20:41:34
Subject: Re: DTrace probes patch
Previous:From: Kevin GrittnerDate: 2008-12-24 20:06:18
Subject: Re: incoherent view of serializable transactions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group