Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Date & Time

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: kaiq(at)realtyideas(dot)com
Cc: "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu>, Dale Anderson <danderso(at)crystalsugar(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Date & Time
Date: 1999-11-30 23:58:25
Message-ID: 199911302358.SAA25326@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
> "now" performs better in this case: 
> insert into test values (123, 'now','Name');
> 
> now() is needed for "default" in create table, because
> "now" won't work right (a bug/feature ?). 
> 

Why does 'now' preform better than now()?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist(at)candle(dot)pha(dot)pa(dot)us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-general by date

Next:From: kaiqDate: 1999-12-01 00:04:30
Subject: Re: [GENERAL] Date & Time
Previous:From: Ross J. ReedstromDate: 1999-11-30 22:48:13
Subject: Re: [GENERAL] Date & Time

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group