Scott Marlowe wrote:
I think you missed the first part of the conversation...
I sure did. Sorry...
Regards,
Thomas Hallgren
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Thu, 2005-04-21 at 10:21, Thomas Hallgren wrote:
> Christopher J. Bottaro wrote:
> > Alvaro Herrera wrote:
> > Ahh, thanks for the tip. I guess I'll just stick with
> > timeofday()::timestamp...its more concise anyways...
> >
>
> Why use timeofday() at all? Why not now(). It will return a ti
Thomas Hallgren wrote:
Why use timeofday() at all? Why not now(). It will return a timestamptz
without casts.
For the same reason that the OP couldn't use CURRENT_TIMESTAMP. It
returns the timestamp of the start of the transaction.
--
Alban Hertroys
MAG Productions
T: +31(0)53 4346874
F: +31(0)5
On Thu, 2005-04-21 at 09:52, Christopher J. Bottaro wrote:
> Alvaro Herrera wrote:
>
> > On Thu, Apr 21, 2005 at 09:22:26AM -0500, Christopher J. Bottaro wrote:
> >> John DeSoi wrote:
> >>
> >> >
> >> > On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
> >> >
> >> >> I understand that
Christopher J. Bottaro wrote:
Alvaro Herrera wrote:
On Thu, Apr 21, 2005 at 09:22:26AM -0500, Christopher J. Bottaro wrote:
John DeSoi wrote:
On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it
Alvaro Herrera wrote:
> On Thu, Apr 21, 2005 at 09:22:26AM -0500, Christopher J. Bottaro wrote:
>> John DeSoi wrote:
>>
>> >
>> > On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
>> >
>> >> I understand that CURRENT_TIMESTAMP marks the beginning of the current
>> >> transaction. I wa
On Thu, Apr 21, 2005 at 09:22:26AM -0500, Christopher J. Bottaro wrote:
> John DeSoi wrote:
>
> >
> > On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
> >
> >> I understand that CURRENT_TIMESTAMP marks the beginning of the current
> >> transaction. I want it to be the actual time. Ho
John DeSoi wrote:
>
> On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
>
>> I understand that CURRENT_TIMESTAMP marks the beginning of the current
>> transaction. I want it to be the actual time. How do I do this?
>> timeofday() returns a string, how do I convert that into a TIMESTAM
Try SELECT timeofday()::TIMESTAMP;
Regards,
Ben
""Christopher J. Bottaro"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> I understand that CURRENT_TIMESTAMP marks the beginning of the current
> transaction. I want it to be the actual time. How do I do this?
> timeofday()
On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it to be the actual time. How do I do this?
timeofday() returns a string, how do I convert that into a TIMESTAMP?
timeofday()::timestamp;
Is it p
Hi,
I understand that CURRENT_TIMESTAMP marks the beginning of the current
transaction. I want it to be the actual time. How do I do this?
timeofday() returns a string, how do I convert that into a TIMESTAMP?
Is it possible to create a column with DEFAULT value evaluated to the actual
current t
11 matches
Mail list logo