Re: How to approach converting to CDBI?

[prev] [thread] [next] [Date index for 2005/07/04]

From: Mike Whitaker
Subject: Re: How to approach converting to CDBI?
Date: 16:21 on 04 Jul 2005

On 4 Jul 2005, at 17:18, Michael Peters wrote:

> - TIMESTAMPs are indiscriminant. The first one will change with each
> update no matter what. What happens if you want a column that only
> occasionally gets set to NOW()? For instance, what if you have a
> 'resolved' column in an issues database. You don't want it updated to
> NOW() until the issue is finished and then never again.


update table set col1='value',timestamp=timestamp where ....;

# preserves value of field timestamp rather than setting it to now.

How to approach converting to CDBI?
Brett Sanger 15:45 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 16:07 on 04 Jul 2005

Re: How to approach converting to CDBI?
Mike Whitaker 16:09 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 16:18 on 04 Jul 2005

Re: How to approach converting to CDBI?
Mike Whitaker 16:21 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 16:28 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 16:20 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 17:56 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 17:27 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 17:36 on 04 Jul 2005

Re: How to approach converting to CDBI?
Jonathan Tweed 18:09 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 18:40 on 04 Jul 2005

Re: How to approach converting to CDBI?
Tony Bowden 20:39 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 20:48 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 21:49 on 04 Jul 2005