Re: [GENERAL] timestamps

>>>>> "s" == strawman  <strawman@plexi.com> writes:

 s> I'm trying to create a column that defaults to the current time and date. I
 s> tried the SQLServer like syntax below but potgresql choked:

 s> CREATE TABLE clicks (
 s> avo_userid varchar (10) NOT NULL ,
 s> link_id int NOT NULL ,
 s> the_time timestamp NOT NULL CONSTRAINT df_now DEFAULT (timestamp('now'))
 s> );
 s> NOTICE:  there is more than one function named "timestamp"
 s> NOTICE:  that satisfies the given argument types. you will have to
 s> NOTICE:  retype your query using explicit typecasts.
 s> ERROR:  function timestamp(unknown) does not exist

 s> Is "timestamp" not both a type and a function? How can I look it
up?

There are data type named 'timestamp' and more than one function for
converting 'timestamp' -> other data type. B.e.

timestamp(data)
timestamp(datetime)
... etc

All of them have the same name - 'timestamp', but different type of
argument(s).

In your case parser dont know - what type of argument you use. You
must 'retype your query using explicit typecasts':

the_time timestamp NOT NULL CONSTRAINT df_now DEFAULT (timestamp('now'::datetime))




 s> And one more question: How does one construct a foreign key relationship in
 s> postgres?

In 6.4 there are no really 'primary ney - foreign key' constraint. If
you wont have this feature you must use 'refint' from postgres
contribs.



--
Anatoly K. Lasareff              Email:       tolik@icomm.ru
Senior programmer