Postgres Pro
Downloads
Home   >   mailing lists

Re: Could not create a table named "USER" under postgreSQL - Mailing list pgsql-general

From gnari
Subject Re: Could not create a table named "USER" under postgreSQL
Date
Msg-id 004801c48554$b711a330$0100000a@wp2000
Whole thread Raw
In response to Could not create a table named "USER" under postgreSQL  (Ying Lu <ying_lu@cs.concordia.ca>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Date and Timestamps
Next
From: "Dann Corbit"
Date:
Subject: Re: Could not create a table named "USER" under postgreSQL