On Thu, May 13, 2010 at 10:09:51AM +, Jasen Betts wrote:
> On 2010-05-12, Josh wrote:
> don't need a function for that one.
>
> INSERT INTO unpart_tbl_test
> SELECT GENERATE_SERIES(0,999),
> 'teststring data',
> date '1995-01-01' +(floor(random()*36520)::int % 3652);
...and
On 2010-05-12, Josh wrote:
> Hello, I'm a little new at this so please bear with me.
>
> 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.
>
> I'm trying to do this in PGAdmin III for Ubuntu. I
d 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 wrote:
> I am trying to create a function that loads 100M test records into a
> database, however I am having a h
On Wed, May 12, 2010 at 10:32 AM, Josh 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
On 05/12/2010 01:32 PM, Josh wrote:
Hello, I'm a little new at this so please bear with me.
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.
I'm trying to do this in PGAdmin III for Ubuntu. Is
Hello, I'm a little new at this so please bear with me.
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.
I'm trying to do this in PGAdmin III for Ubuntu. Is there something
that I have wrong w
Ken Kline <[EMAIL PROTECTED]> writes:
> it is to be server side code
> the code I gave you was merely an example
> of a cursor that I found when I did a search...
> http://www.armed.net/how/pg001676.htm
I think Tom addressed how to solve your actual problem.
I'll just comment that the examp
Ken Kline <[EMAIL PROTECTED]> writes:
> orginally what I wanted to do was this:
> INSERT INTO pledge_classes (semester, year)
> SELECT distinct pseason, pyear from load_bros
> WHERE pyear is not null
> ANDpseason is not null
> order by pyear, pseason;
> however pgsql does not allow order by
it is to be server side code
the code I gave you was merely an example
of a cursor that I found when I did a search...
http://www.armed.net/how/pg001676.htm
orginally what I wanted to do was this:
INSERT INTO pledge_classes (semester, year)
SELECT distinct pseason, pyear from load_bros
WHERE
Ian Lance Taylor <[EMAIL PROTECTED]> writes:
> PL/pgSQL does not support cursors. It also does not support goto.
The context is pretty unclear here, but perhaps he needs ecpg not
plpgsql ... is this to be client- or server-side code?
regards, tom lane
Ken Kline <[EMAIL PROTECTED]> writes:
> I have just joined the list a few days ago and am trying quite hard
> to come up to speed with pgsql but i find documentaion frustratiing.
> I think maybe it;s just a matter of finding things that are of the
> correct
> scope. I've been an Oracle developer
I have just joined the list a few days ago and am trying quite hard
to come up to speed with pgsql but i find documentaion frustratiing.
I think maybe it;s just a matter of finding things that are of the
correct
scope. I've been an Oracle developer for over 6 years so often I
know what it is I wa
12 matches
Mail list logo
