DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:cc:subject:references:mime-version
	:content-type:content-disposition:in-reply-to:user-agent;
	b=KT8ZxVEgS1pJe8S7tMLy/MW7dhq7tWyQHCisPdLQbZw1aoNi4hjIWmu2QIaCrfegUg
	IqC6UbQAbAkSNQXkMADY+gQewMPxEAMAmb3ow7fenkseKw0AsdtjHKxGICSUEY2IVY/d
	C7rbamwgXwLFbOrNXIEyII1ILiLyYrXzrbmS0=
Message-ID: <4bebf2ae.1249650a.19f4.2ea8@mx.google.com>
Date: Thu, 13 May 2010 06:37:56 -0600
From: Joshua Tolley <eggyknap@gmail.com>
To: Jasen Betts <jasen@xnet.co.nz>
Cc: pgsql-sql@postgresql.org
Subject: Re: Greetings folks, dumb question maybe?
References: <4BEAE646.9050902@ttitech.net>
 <hsgj5f$o21$1@reversiblemaps.ath.cx>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="smOfPzt+Qjm5bNGJ"
Content-Disposition: inline
In-Reply-To: <hsgj5f$o21$1@reversiblemaps.ath.cx>
User-Agent: Mutt/1.5.18 (2008-05-17)


--smOfPzt+Qjm5bNGJ
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, May 13, 2010 at 10:09:51AM +0000, Jasen Betts wrote:
> On 2010-05-12, Josh <jgooding@ttitech.net> wrote:
> don't need a function for that one.
>=20
> INSERT INTO unpart_tbl_test=20
>  SELECT  GENERATE_SERIES(0,9999999),
>      'teststring data',
>      date '1995-01-01' +(floor(random()*36520)::int % 3652);

=2E..and if you'd rather it were a function anyway, do this:

CREATE FUNCTION populate_table() RETURNS VOID AS $$
    INSERT INTO unpart_tbl_test=20
     SELECT  GENERATE_SERIES(0,9999999),
         'teststring data',
         date '1995-01-01' +(floor(random()*36520)::int % 3652);
$$ LANGUAGE SQL;

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

--smOfPzt+Qjm5bNGJ
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkvr8qQACgkQRiRfCGf1UMPzWgCbBD3PXXXdZ5fVItWLGB8i5ZbR
Uk4An2Ma1aPlgejAHhF36cGFNKko44uS
=abaA
-----END PGP SIGNATURE-----

--smOfPzt+Qjm5bNGJ--