Re: timestamp value

Поиск
Список
Период
Сортировка
От Ivan Horvath
Тема Re: timestamp value
Дата
Msg-id 20020304103846.14727.qmail@web14702.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: timestamp value  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-novice
thank you very much it is working!

Ivan

--- Oliver Elphick <olly@lfix.co.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.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 по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: timestamp value
Следующее
От: "rob"
Дата:
Сообщение: PL/pgSQL syntax documentation