From: | Ivan Horvath <pillesoft(at)yahoo(dot)co(dot)uk> |
---|---|
To: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
Cc: | pgsql-new <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: timestamp value |
Date: | 2002-03-04 10:38:46 |
Message-ID: | 20020304103846.14727.qmail@web14702.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
thank you very much it is working!
Ivan
--- Oliver Elphick <olly(at)lfix(dot)co(dot)uk> wrote:
> On Mon, 2002-03-04 at 09:49, Ivan Horvath wrote:
> > 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?
>
>
> 1. Do you really need to distinguish
> _within_a_transaction_?
>
> 2. Use timeofday()::TIMESTAMP
> (It's in the docs at User manual 4.8.3)
>
> --
> Oliver Elphick
> Oliver(dot)Elphick(at)lfix(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Somayaji, Rajashekhara | 2002-03-04 11:42:30 | ANSI SQL |
Previous Message | Oliver Elphick | 2002-03-04 10:12:58 | Re: timestamp value |