Received: from localhost (wm.hub.org [200.46.204.128])
	by postgresql.org (Postfix) with ESMTP id 5D4119FB318
	for <pgsql-general-postgresql.org@postgresql.org>;
	Tue, 17 Oct 2006 06:07:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024)
	with ESMTP id 45562-10 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Tue, 17 Oct 2006 09:07:28 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.190])
	by postgresql.org (Postfix) with ESMTP id D4A3B9FB411
	for <pgsql-general@postgresql.org>;
	Tue, 17 Oct 2006 06:07:27 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id i2so237235nfe
	for <pgsql-general@postgresql.org>;
	Tue, 17 Oct 2006 02:07:25 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=TNbNd0RtQ2PYdNm+pa+ygT4IDm1opFXz+GBaQR2+73WpihkEikrIL5jPuCX6kA97yE1nGBpAKXxsIbj04KF2FqzvhFrwIPOJ9zjVl7mHByvklimfhl9AOBmvsi18x42+esvDLDc0WwNEVIcDF5II/Y2u2vjzlnUQjSmZ/LElVBA=
Received: by 10.82.111.8 with SMTP id j8mr1309378buc;
	Tue, 17 Oct 2006 02:07:25 -0700 (PDT)
Received: by 10.82.162.15 with HTTP; Tue, 17 Oct 2006 02:07:25 -0700 (PDT)
Message-ID: <c44bd2680610170207y547f5641p4120e7a2b7ecdfd1@mail.gmail.com>
Date: Tue, 17 Oct 2006 17:07:25 +0800
From: "Felix Zhang" <felix.zhang.2005@gmail.com>
To: "Andreas Kretschmer" <akretschmer@spamfence.net>
Subject: Re: [NOVICE] How to split a table?
Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org,
	pgsql-novice@postgresql.org
In-Reply-To: <20061017083418.GA3917@KanotixBox>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_32332_20057970.1161076045350"
References: <c44bd2680610170039j3342e874ue78bc71a701f76e0@mail.gmail.com>
	<20061017083418.GA3917@KanotixBox>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.334 tagged_above=0 required=5
	tests=DNS_FROM_RFC_ABUSE, HTML_50_60, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200610/797
X-Sequence-Number: 102323

------=_Part_32332_20057970.1161076045350
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

to do some statistics analysis.

2006/10/17, Andreas Kretschmer <akretschmer@spamfence.net>:
>
> Felix Zhang <felix.zhang.2005@gmail.com> schrieb:
>
> > Hi,
> >
> > I want to split a table to 2 small tables. The 1st one contains 60%
> records
> > which are randomly selected from the source table.
> > How to do it?
>
> Why do you want to do this?
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect.                              (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly."    (unknow)
> Kaufbach, Saxony, Germany, Europe.              N 51.05082=B0, E 13.56889=
=B0
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>

------=_Part_32332_20057970.1161076045350
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

to do some statistics analysis.<br><br>
<div><span class=3D"gmail_quote">2006/10/17, Andreas Kretschmer &lt;<a href=
=3D"mailto:akretschmer@spamfence.net">akretschmer@spamfence.net</a>&gt;:</s=
pan>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Felix Zhang &lt;<a href=3D"mailt=
o:felix.zhang.2005@gmail.com">felix.zhang.2005@gmail.com</a>&gt; schrieb:<b=
r>
<br>&gt; Hi,<br>&gt;<br>&gt; I want to split a table to 2 small tables. The=
 1st one contains 60% records<br>&gt; which are randomly selected from the =
source table.<br>&gt; How to do it?<br><br>Why do you want to do this?<br>
<br><br>Andreas<br>--<br>Really, I'm not out to destroy Microsoft. That wil=
l just be a completely<br>unintentional side effect.&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;(Linus Torvalds)<br>&quot;If I was god, I would recompile penguin wi=
th --enable-fly.&quot;&nbsp;&nbsp;&nbsp;&nbsp;(unknow)
<br>Kaufbach, Saxony, Germany, Europe.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;N 51.05082=B0, E 13.56889=B0=
<br><br>---------------------------(end of broadcast)----------------------=
-----<br>TIP 4: Have you searched our list archives?<br><br>&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<a href=3D"http://archives.postgresql.org">http://archives.postgresql.org</=
a><br></blockquote></div><br>

------=_Part_32332_20057970.1161076045350--