On Tue, 23 Mar 1999, Roberto Joao Lopes Garcia wrote:
> Hi
>
> I�m have a table like bellow:
>
> CREATE TABLE conex (
> id int4 PRIMARY KEY DEFAULT NEXTVAL('seq_conex'),
>
> inicio datetime DEFAULT TEXT 'now',
> ultimo datetime DEFAULT TEXT
> 'now',
> .
> .
> .
> )
>
> insert into conex (ip) values(�200.200.200.200�)
>
> Will result every time the same data and time for �inicio� and �ultimo�!
>
> I want to insert the current date and time. Is that code correct and the
> result a bug???
> Is there an way to make the DEFAULT work???
try:
...
inicido DATETIME DEFAULT NOW(),
ultimo DATETIME DEFAULT NOW(),
...
---
Howie <caffeine@toodarkpark.org> URL: http://www.toodarkpark.org
"You can change the world with a bullet in the right place"