Re: timestamp value - Mailing list pgsql-novice

From Ivan Horvath
Subject Re: timestamp value
Date
Msg-id 20020304094932.38297.qmail@web14703.mail.yahoo.com
Whole thread Raw
In response to Re: timestamp value  (Oliver Elphick <olly@lfix.co.uk>)
Responses Re: timestamp value
List pgsql-novice
Oliver,

then what can i do -regarding timestamp- if i need to
create such a routine, so called "batch-processing",
which writes data to a table, or more tables at the
same time?
how can i ask the real timestamp value within a stored
procedure?

Ivan

--- Oliver Elphick <olly@lfix.co.uk> wrote:
> On Mon, 2002-03-04 at 07:45, Ivan Horvath wrote:
> > Thanks for answer,
> >
> > here is the code of the stored procedure:
> >
> > DROP FUNCTION a_function();
> >
> > CREATE FUNCTION a_function () RETURNS interval AS
> '
>
> In 7.2 you can now do CREATE OR REPLACE FUNCTION...
> rather than DROP
> followed by CREATE.
>
> > DECLARE
> >         process_time interval;
> > BEGIN
> >         FOR i IN 1..10000 LOOP
> >             INSERT INTO unit (unit_name, mod_date)
> > VALUES (''a'', current_timestamp);
> >         END LOOP;
> >
> >         select into process_time max(mod_date) -
> > min(mod_date) from unit;
> >
> >         RETURN process_time;
> >
> > END;'
> > LANGUAGE 'plpgsql';
>
>
> All operations within a plpgsql procedure happen
> within a transaction
> and within a transaction current_timestamp does not
> change (by design).
> So each separate call to this procedure will produce
> 10000 identical
> inserts.
>
> --
> Oliver Elphick
> Oliver.Elphick@lfix.co.uk
> Isle of Wight
> http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A
> 614D 4C34 3E1D 0C1C
>
>      "Give, and it will be given to you. A good
> measure,
>       pressed down, taken together and running over,
>
>       will be poured into your lap. For with the
> same
>       measure that you use, it will be measured to
>       you."         Luke 6:38
>


__________________________________________________
Do You Yahoo!?
Yahoo! Sports - sign up for Fantasy Baseball
http://sports.yahoo.com

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: timestamp value
Next
From: Oliver Elphick
Date:
Subject: Re: timestamp value