List:General Discussion« Previous MessageNext Message »
From:Jochem van Dieten Date:June 9 2005 8:47pm
Subject:Re: Seriously.. When are we going to get subqueries?!
View as plain text  
On 6/9/05, daniel@stripped wrote:
> 
> Okay, so I understand the idea about one field being the "creation" time, and
> the other being the "last modified" time (which a particularly pedantic
> application might regard as being one-and-the-same, at time of
> first-creation) and so I see you might want to _store_ that fact in both
> fields at time of creation: but even so, there is a fundamental difference of
> type between the two fields, that remains, that is much more important than
> the fact you can declare them both as DEFAULT NOW()... "Time of creation"
> must never change; or it's existence is useless. "Time of modification" must
> _always_ change; or it's existence is useles.

Not necessarily. Sometimes you want to differentiate between 'Last
user modification' and 'Last process modification'. One way to handle
that is in a trigger based upon the group membership of the user
making the change.


> That kind of logic can only really be enforced by external business rules
> built into the code, anyway, can't it?

No.

Jochem
Thread
Seriously.. When are we going to get subqueries?!Kevin Burton7 Jun
  • Re: Seriously.. When are we going to get subqueries?!Greg Whalin7 Jun
    • Re: Seriously.. When are we going to get subqueries?!Kevin Burton8 Jun
  • Re: Seriously.. When are we going to get subqueries?!DBA8 Jun
    • Re: Seriously.. When are we going to get subqueries?!Kevin Burton8 Jun
  • Re: Seriously.. When are we going to get subqueries?!Jeff Smelser8 Jun
    • Re: Seriously.. When are we going to get subqueries?!Dan Nelson8 Jun
      • Re: Seriously.. When are we going to get subqueries?!Jeff Smelser8 Jun
        • Re: Seriously.. When are we going to get subqueries?!Kevin Burton9 Jun
          • Re: Seriously.. When are we going to get subqueries?!Jochem van Dieten9 Jun
            • Re: Seriously.. When are we going to get subqueries?!Kevin Burton10 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard8 Jun
  • Re: Seriously.. When are we going to get subqueries?!Jeff Smelser8 Jun
  • Re: Seriously.. When are we going to get subqueries?!Martijn Tonies8 Jun
  • RE: Seriously.. When are we going to get subqueries?!George Sexton9 Jun
    • Re: Seriously.. When are we going to get subqueries?!Jeff Smelser9 Jun
    • Re: Seriously.. When are we going to get subqueries?!Josh Trutwin9 Jun
    • Re: Seriously.. When are we going to get subqueries?!Keith Ivey9 Jun
      • Re: Seriously.. When are we going to get subqueries?!Jochem van Dieten9 Jun
      • Re: Seriously.. When are we going to get subqueries?!George L. Sexton9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard8 Jun
  • Re: Seriously.. When are we going to get subqueries?!Jeff Smelser8 Jun
  • Re: Seriously.. When are we going to get subqueries?!Greg Whalin8 Jun
    • Re: Seriously.. When are we going to get subqueries?!Kevin Burton9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard8 Jun
RE: Seriously.. When are we going to get subqueries?!PMilanese8 Jun
Re: Seriously.. When are we going to get subqueries?!Bob_Savard8 Jun
  • Re: Seriously.. When are we going to get subqueries?!Boyd Lynn Gerber9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard9 Jun
  • Re: Seriously.. When are we going to get subqueries?!Gordan Bobic9 Jun
  • RE: Seriously.. When are we going to get subqueries?!George Sexton9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard9 Jun
  • Re: Seriously.. When are we going to get subqueries?!Gordan Bobic9 Jun
    • Re: Seriously.. When are we going to get subqueries?!Josh Trutwin9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard9 Jun
  • Re: Seriously.. When are we going to get subqueries?!Gordan Bobic9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard9 Jun
  • RE: Seriously.. When are we going to get subqueries?!George Sexton9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard9 Jun
  • RE: Seriously.. When are we going to get subqueries?!George Sexton9 Jun
    • Re: Seriously.. When are we going to get subqueries?!Jeff Smelser9 Jun
      • Re: Seriously.. When are we going to get subqueries?!George L. Sexton9 Jun
        • Re: Seriously.. When are we going to get subqueries?!Roger B.A. Klorese 9 Jun
          • Re: Seriously.. When are we going to get subqueries?!Jochem van Dieten9 Jun
        • Re: Seriously.. When are we going to get subqueries?!Jeff Smelser9 Jun
          • Re: Seriously.. When are we going to get subqueries?!Greg Whalin9 Jun
            • Re: Seriously.. When are we going to get subqueries?!daniel9 Jun
              • Re: Seriously.. When are we going to get subqueries?!Jochem van Dieten9 Jun
  • Re: Seriously.. When are we going to get subqueries?!David Griffiths9 Jun
    • RE: Seriously.. When are we going to get subqueries?!J.R. Bullington9 Jun
Re: Seriously.. When are we going to get subqueries?!George L. Sexton9 Jun
RE: Seriously.. When are we going to get subqueries?!Bob)9 Jun
  • Re: Seriously.. When are we going to get subqueries?!Jochem van Dieten9 Jun
RE: Seriously.. When are we going to get subqueries?!Jay Blanchard9 Jun
RE: Seriously.. When are we going to get subqueries?!Gordon Bruce9 Jun
  • Timestamp and it's usage (Re: Seriously.. When are we going to get subqueries?!)Martijn Tonies9 Jun
    • Re: Timestamp and it's usage (Re: Seriously.. When are we going to get subqueries?!)Jochem van Dieten9 Jun
  • Re: Timestamp and it's usage (Re: Seriously.. When are we going to get subqueries?!)Martijn Tonies9 Jun