> Excuse me does the 'current'::datetime work ?
Sure. But the behavior one might want from 'current' requires that
printing or representing it in its raw form preserves its
"current-ness". If you want 'current' instantiated into a time, you
have to do some math, or some other operation which will nail it to
the time you evaluate it. Here is an example:
postgres=> select datetime 'now' as now,
postgres-> datetime 'current' as current,
postgres-> datetime 'current' + timespan '0 sec' as equiv;
now |current|equiv
----------------------+-------+----------------------
1999-10-11 15:09:58+00|current|1999-10-11 15:09:58+00
(1 row)
Hope this helps. Good luck.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California