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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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;
;]
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-12-24 20:41:34 | Re: DTrace probes patch |
Previous Message | Kevin Grittner | 2008-12-24 20:06:18 | Re: incoherent view of serializable transactions |