Re: timestamp value

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

In response to

Browse pgsql-novice by date

  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