Re: Szybkie wypełnianie zerami tabeli

Article View: pl.comp.bazy-danych

Article #195198

Back to pl.comp.bazy-danych Previous Next

#195198

From: Cezary Grądys
Date: Fri, 20 Jan 2017 10:47

22 lines
1708 bytes

W dniu 20.01.2017 o 11:27, Paweł Broda pisze:
> WITH RECURSIVE x AS
> (
>   SELECT 1 AS a, 0 AS b, 0 AS c
>   UNION ALL
>   SELECT 1+a, b, c FROM x WHERE n<100000
> )
> SELECT * FROM x


Tylko a, a nie n we WHERE!

SELECT * FROM x;
test=> WITH RECURSIVE x AS
(
   SELECT 1 AS a, 0 AS b, 0 AS c
   UNION ALL
   SELECT 1+a, b, c FROM x WHERE a<100000
)
SELECT * FROM x;

Na postgresie działa

Technical Details

Message-ID: <5881eac8$0$15207$65785112@news.neostrada.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!peer03.am4!peer.am4.highwinds-media.com!peer02.fr7!futter-mich.highwinds-media.com!news.highwinds-media.com!newsfeed.neostrada.pl!unt-exc-02.news.neostrada.pl!unt-spo-b-01.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mail

References:

<o5sn7j$9es$1@node1.news.atman.pl> <bfee7e61-5c91-4ecb-9bf4-58669fd86424@googlegroups.com> <o5sniu$9n7$1@node1.news.atman.pl> <e6fc45bd-6dc5-4c69-9e4b-42f7723e5351@googlegroups.com>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!peer03.am4!peer.am4.highwinds-media.com!peer02.fr7!futter-mich.highwinds-media.com!news.highwinds-media.com!newsfeed.neostrada.pl!unt-exc-02.news.neostrada.pl!unt-spo-b-01.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mail
Subject: Re: Szybkie wypełnianie zerami tabeli
Newsgroups: pl.comp.bazy-danych
References: <o5sn7j$9es$1@node1.news.atman.pl> <bfee7e61-5c91-4ecb-9bf4-58669fd86424@googlegroups.com> <o5sniu$9n7$1@node1.news.atman.pl> <e6fc45bd-6dc5-4c69-9e4b-42f7723e5351@googlegroups.com>
From: Cezary Grądys <czarekgr@wa.onet.pl>
Date: Fri, 20 Jan 2017 11:47:36 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.5.1
MIME-Version: 1.0
In-Reply-To: <e6fc45bd-6dc5-4c69-9e4b-42f7723e5351@googlegroups.com>
Lines: 23
Message-ID: <5881eac8$0$15207$65785112@news.neostrada.pl>
Organization: Telekomunikacja Polska
NNTP-Posting-Host: public719410.centertel.pl
X-Trace: 1484909256 unt-rea-a-02.news.neostrada.pl 15207 5.185.97.115:49972
X-Complaints-To: abuse@news.neostrada.pl
X-Received-Bytes: 1487
X-Received-Body-CRC: 365924400
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message