Re: Could not create a table named "USER" under postgreSQL

"Ying Lu" <ying_lu@cs.concordia.ca> wrote:
>
> I have a question about "date" & "timestamp" types in PostgreSQL. I want
> to setup the default value '0000-00-00' and "0000-00-00 00:00:00" for
> them. However, it seems that PostgreSQL does not support it. Could
> someone helps me please?

if you want to store invalid dates and timestamps, you
are better off using varchar.

if you just want to store a null-value, use NULL

does mysql really allow you to store these values?

gnari