Re: Szybkie wypełnianie zerami tabeli

Article View: pl.comp.bazy-danych

Article #195197

Back to pl.comp.bazy-danych Previous Next

#195197

From: Paweł Broda
Date: Fri, 20 Jan 2017 10:27

9 lines
1563 bytes

spróbuj zmergować to zapytanie do twojej tabeli:

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

Technical Details

Message-ID: <e6fc45bd-6dc5-4c69-9e4b-42f7723e5351@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!r185no794657ita.0!news-out.google.com!78ni13206itm.0!nntp.google.com!r185no794650ita.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!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>

Show Full Headers

Complete Article Headers

X-Received: by 10.157.17.149 with SMTP id v21mr3709632otf.145.1484908028817;        Fri, 20 Jan 2017 02:27:08 -0800 (PST)
X-Received: by 10.157.41.149 with SMTP id n21mr1401861otb.4.1484908028748; Fri, 20 Jan 2017 02:27:08 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!r185no794657ita.0!news-out.google.com!78ni13206itm.0!nntp.google.com!r185no794650ita.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych
Date: Fri, 20 Jan 2017 02:27:08 -0800 (PST)
In-Reply-To: <o5sniu$9n7$1@node1.news.atman.pl>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=194.0.240.206; posting-account=fKvxEAoAAAAaXZSkKFQkID0nr0tgYJgq
NNTP-Posting-Host: 194.0.240.206
References: <o5sn7j$9es$1@node1.news.atman.pl> <bfee7e61-5c91-4ecb-9bf4-58669fd86424@googlegroups.com> <o5sniu$9n7$1@node1.news.atman.pl>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e6fc45bd-6dc5-4c69-9e4b-42f7723e5351@googlegroups.com>
Subject: Re: Szybkie wypełnianie zerami tabeli
From: Paweł Broda <pawel.a.broda@gmail.com>
Injection-Date: Fri, 20 Jan 2017 10:27:08 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message