Re: timestamp with/without time zone - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: timestamp with/without time zone
Date
Msg-id 200106181900.f5IJ0Hh18159@candle.pha.pa.us
Whole thread Raw
In response to Re: timestamp with/without time zone  (Alex Pilosov <alex@pilosoft.com>)
List pgsql-hackers
> We don't have it. Its just that it is misleading to have 'timestamp with
> time zone' as description of this type, when 'timestamp without time zone' 
> does not exist. (Actually, if you try to create a field as 'timestamp
> without time zone', you get timestamp anyway). Since you can't have
> 'without', why mention that the type has a time zone?
> 

Totally agree.  I see in psql's \dT:
time with time zone      | hh:mm:ss, ANSI SQL timetimestamp with time zone | date and time

Looks like 'time' has a similar problem.  Let me know if I can help.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: timestamp with/without time zone
Next
From: Tom Lane
Date:
Subject: Re: corrupted document in 7.1.2