Re: Greetings folks, dumb question maybe?

I've been using the generate_series function and finding it very useful. It generates an integer, but I cast to 'day'
interval.
Might be useful.
doug

-----Original Message-----
From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Richard Broersma
Sent: Wednesday, May 12, 2010 4:05 PM
To: Josh
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Greetings folks, dumb question maybe?

On Wed, May 12, 2010 at 10:32 AM, Josh <jgooding@ttitech.net> wrote:

> I am trying to create a function that loads 100M test records into a
> database,  however I am having a hard time building the function that does
> so.

Here is one idea a function, but is could be wrapped by one:

p2082849b=> INSERT INTO Testtable ( n, c, d )
p2082849b-> WITH RECURSIVE T(n,c,d) as ( SELECT 1, 'A', CAST(
'2009-12-31' AS DATE ) + INTERVAL '1 DAY'
p2082849b(>                    UNION ALL SELECT n + 1, c, d + INTERVAL '1 day'
p2082849b(>                                FROM T
p2082849b(>                               WHERE n <= 10000)
p2082849b-> SELECT n,c,d FROM T;
INSERT 0 10001


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql