Обсуждение: Re: Default 'now'

> ... and what worked for me was:  default (datetime(now())
>
> So, the reason I'm annoying you now is this:  For some time now, I've
> been wondering what version of PostgreSQL my ISP has running.  He's
> never answered that particular query, and the version files are not
> readable by lowly me.
>
> So, can you tell me in what version of PostgreSQL this worked/broke?

postgres=> create table t (i int,
postgres-> d datetime default datetime(text 'now'));
CREATE

Works now. Have you tried

postgres=> select version();
version
--------------------------------------------------------------
PostgreSQL 6.4.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.1
(1 row)

The CVS log shows something was added back in 1996. Don't know if it
actually worked back then though...
revision 1.1
date: 1996/08/28 01:57:23;  author: scrappy;

Hi all

Could this be added to the FAQ for regular users? Something like "How do I know
what version I'm using?"

Just a thought.

On Aug 7,  5:23am, Thomas G. Lockhart wrote:
> Works now. Have you tried
>
> postgres=> select version();
> version
> --------------------------------------------------------------
> PostgreSQL 6.4.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.1
> (1 row)

--
Sincerely,

Jazzman (a.k.a. Justin Hickey)  e-mail: jhickey@hpcc.nectec.or.th
High Performance Computing Center
National Electronics and Computer Technology Center (NECTEC)
Bangkok, Thailand
==================================================================
People who think they know everything are very irritating to those
of us who do.  ---Anonymous

Jazz and Trek Rule!!!
==================================================================

Added to FAQ.

> Hi all
>
> Could this be added to the FAQ for regular users? Something like "How do I know
> what version I'm using?"
>
> Just a thought.
>
> On Aug 7,  5:23am, Thomas G. Lockhart wrote:
> > Works now. Have you tried
> >
> > postgres=> select version();
> > version
> > --------------------------------------------------------------
> > PostgreSQL 6.4.0 on i686-pc-linux-gnu, compiled by gcc 2.7.2.1
> > (1 row)
>
> --
> Sincerely,
>
> Jazzman (a.k.a. Justin Hickey)  e-mail: jhickey@hpcc.nectec.or.th
> High Performance Computing Center
> National Electronics and Computer Technology Center (NECTEC)
> Bangkok, Thailand
> ==================================================================
> People who think they know everything are very irritating to those
> of us who do.  ---Anonymous
>
> Jazz and Trek Rule!!!
> ==================================================================
>
>


--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)