From: Josh Berkus <josh@agliodbs.com>
To: pgsql-sql@postgresql.org
Subject: Re: Date/Time types
Date: Fri, 27 Sep 2002 09:01:27 -0700
Message-ID: <web-1731878@davinci.ethosmedia.com> (raw)
In-Reply-To: <amenp5$1mtv$1@news.hub.org>
Seb,
> I'm french, so excuse me if my english is not correct.
Whereas if you were a native English speaker, you would realize that
there is no such thing as "correct English" .... <grin>
> I'd like to create a table with a Timestamp row (named date for
> example) and
> width a resolution as smaller as possible (1 microsecond if
> possible).
>
> What is exactly the correct query for that question ?
>
> The query I've written is :
> CREATE TABLE "table" (
> "id" int4 NOT NULL,
> "date" timestamp [13] NOT NULL )
Sorry, the syntax above creates a table with an *array* of 13 timestamp
values.
I don't know what the syntax you want for an extra-precision timestamp
is. Assuming there is one at all, which there may not be ...
I'd also advise against creating tables with reserved words (such as
"date" ) as column names. It can cause you all kinds of headaches
later on,
-Josh Berkus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com
Subject: Re: Date/Time types
In-Reply-To: <web-1731878@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox