From: | "Frdric SURLEAU" <frederic(dot)surleau(at)atosorigin(dot)com> |
---|---|
To: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | About timestamp and timestamptz |
Date: | 2002-11-22 09:36:10 |
Message-ID: | 3DDDFA8A.00000A.00444@75A03767 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi,
I think there is a problem with the timestamp types in postgresql 7.2.3.
In the documentation here http://www.postgresql.org/idocs/index.php?datatype
html the table 3-1 says:
timestamp [ (p) ] without time zonetimestampdate and time
timestamp [ (p) ] [ with time zone ]timestamptzdate and time, including time
zone
So if I use the type "timestamp", it will not use the alias "timestamp" for
timestamp without time zone", but it will use a "timestamptz" because "with
time zone" is optional.
Conclusion :
1- To have a timestamp without time zone I must say "timestamp without time
zone"
2- The alias "timestamp" can't be used and should be removed or replaced.
Or the table should be :
timestamp [ (p) ] [ without time zone ]date and time
timestamp [ (p) ] with time zonetimestamptzdate and time, including time
zone
like it's the case for time :
time [ (p) ] [ without time zone ] time of day
time [ (p) ] with time zonetimetztime of day, including time zone
Regards,
Fred.
PS in real world, I can use "timestamp with time zone", but I have the
problem when using PhpPgAdmin, who reads the datatypes available from
pg_type" where only aliases are listed.
I tried to fix the problem in PhpPgAdmin looking for another way to read data-types, but I didn't found it.
From | Date | Subject | |
---|---|---|---|
Next Message | Philip Warner | 2002-11-22 14:13:03 | Re: Is this planner choice easily explained? |
Previous Message | i | 2002-11-21 19:47:48 | Help me~! MemoryContextAlloc Error 1!! Major bug |