View Single Post

   
  #4 (permalink)  
Old 04-19-2008, 12:49 PM
Michael Glaesemann
 
Posts: n/a
Default Re: Update timestamp on update


On Oct 13, 2005, at 11:52 , Tom Lane wrote:

> Jeff Williams <jeffw@globaldial.com> writes:
>
>> Thanks. Triggers was my first thought, but chapter 35 on Triggers
>> didn't
>> really indicate a way I could do this easily and scared me with a
>> lot of
>> c code.
>>

>
> Yeah. This is a documentation issue that's bothered me for awhile.
> The problem is that we treat the PL languages as add-ons and therefore
> the documentation of the "core" system shouldn't rely on them ... but
> that leaves us presenting C-code triggers as the only examples in
> chapter 35. There is a paragraph in there suggesting you go look at
> the PL languages first, but obviously it's not getting the job done.


I think examples in PL/pgSQL would perhaps be most appropriate, as
it's a PostgreSQL-specific language, arguably easy to read, and a PL
that doesn't rely on any external dependencies, so it should be
relatively easy for people to install it if they want. (IIRC, there's
even been discussion in the past of whether or not PL/pgSQL should be
installed by default.)


Michael Glaesemann
grzm myrealbox com




---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Reply With Quote