public inbox for [email protected]
help / color / mirror / Atom feedtimestamptz alias
18+ messages / 9 participants
[nested] [flat]
* timestamptz alias
@ 2006-10-02 22:15 Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: Markus Schaber @ 2006-10-02 22:15 UTC (permalink / raw)
To: [email protected]
Hi,
I'm happy that the rather verbose "timestamp with time zone" has the
much nicer alias "timestamptz", however it seems that this alias is not
documented, neither at
http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html
nor at http://www.postgresql.org/docs/8.1/interactive/datatype-datetime.html
I see it mentioned at
http://www.postgresql.org/docs/8.1/interactive/datatype.html but that's
possibly not where people look at first, when they search for the
timestamp type. (At least I found it only when grepping for
"timestamptz" in the docs. :-)
Should the alias be mentioned on the datetime page? The same for timetz?
What do you think?
Thanks,
Markus
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
@ 2006-10-02 22:22 ` AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: AgentM @ 2006-10-02 22:22 UTC (permalink / raw)
To: PostgreSQL-development hackers <[email protected]>
On Oct 2, 2006, at 18:15 , Markus Schaber wrote:
> Hi,
>
> I'm happy that the rather verbose "timestamp with time zone" has the
> much nicer alias "timestamptz", however it seems that this alias is
> not
> documented, neither at
> http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html
> nor at http://www.postgresql.org/docs/8.1/interactive/datatype-
> datetime.html
>
> I see it mentioned at
> http://www.postgresql.org/docs/8.1/interactive/datatype.html but
> that's
> possibly not where people look at first, when they search for the
> timestamp type. (At least I found it only when grepping for
> "timestamptz" in the docs. :-)
>
> Should the alias be mentioned on the datetime page? The same for
> timetz?
> What do you think?
I am pleased that the documentation promotes database-independent
("standard") SQL.
-M
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
@ 2006-10-03 01:26 ` Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: Jim Nasby @ 2006-10-03 01:26 UTC (permalink / raw)
To: AgentM <[email protected]>; +Cc: PostgreSQL-development hackers <[email protected]>
On Oct 2, 2006, at 6:22 PM, AgentM wrote:
> On Oct 2, 2006, at 18:15 , Markus Schaber wrote:
>> I'm happy that the rather verbose "timestamp with time zone" has the
>> much nicer alias "timestamptz", however it seems that this alias
>> is not
>> documented, neither at
>> http://developer.postgresql.org/pgdocs/postgres/datatype-
>> datetime.html
>> nor at http://www.postgresql.org/docs/8.1/interactive/datatype-
>> datetime.html
>>
>> I see it mentioned at
>> http://www.postgresql.org/docs/8.1/interactive/datatype.html but
>> that's
>> possibly not where people look at first, when they search for the
>> timestamp type. (At least I found it only when grepping for
>> "timestamptz" in the docs. :-)
>>
>> Should the alias be mentioned on the datetime page? The same for
>> timetz?
>> What do you think?
>
> I am pleased that the documentation promotes database-independent
> ("standard") SQL.
There's a difference between promoting and withholding info. I'd
rather see us explicitly state which is preferred and why.
BTW, another confusing example is all the string functions that are
essentially the same, such as substring and substr. (http://
www.postgresql.org/docs/8.1/interactive/functions-string.html)
--
Jim Nasby [email protected]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
@ 2006-10-03 09:20 ` Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: Markus Schaber @ 2006-10-03 09:20 UTC (permalink / raw)
To: ; +Cc: PostgreSQL-development hackers <[email protected]>
Hi, Jim,
Jim Nasby wrote:
> There's a difference between promoting and withholding info. I'd rather
> see us explicitly state which is preferred and why.
Here's a small patch that adds an appropriate explanation.
Index: doc/src/sgml/datatype.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/datatype.sgml,v
retrieving revision 1.176
diff -u -r1.176 datatype.sgml
--- doc/src/sgml/datatype.sgml 22 Sep 2006 16:20:00 -0000 1.176
+++ doc/src/sgml/datatype.sgml 3 Oct 2006 09:14:32 -0000
@@ -1372,6 +1372,17 @@
</para>
</note>
+ <note>
+ <para>
+ <productname>PostgreSQL</productname> also supports the aliases
+ <type>timestamptz</type> for <type>timestamp with time zone</type>
+ and <type>timetz</type> for <type>time with time zone</type>. It
+ is recommended to avoid them, as the more verbose variants comply
+ to the SQL standard, and thus are more portable. But there are no
+ plans to drop the short aliases in future versions.
+ </para>
+ </note>
+
<para>
<type>time</type>, <type>timestamp</type>, and
<type>interval</type> accept an optional precision value
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
Attachments:
[application/pgp-signature] signature.asc (252B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
@ 2006-10-03 15:33 ` Tom Lane <[email protected]>
2006-10-03 16:13 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-04 09:41 ` Re: timestamptz alias Markus Schaber <[email protected]>
0 siblings, 2 replies; 18+ messages in thread
From: Tom Lane @ 2006-10-03 15:33 UTC (permalink / raw)
To: Markus Schaber <[email protected]>; +Cc: PostgreSQL-development hackers <[email protected]>
Markus Schaber <[email protected]> writes:
> Here's a small patch that adds an appropriate explanation.
If we're going to document these aliases, what of float4, float8, and bool?
Also, although the docs mention int2/int4/int8, it's more or less left
to the reader's imagination to deduce what they are.
Perhaps it'd be better to provide a small table of recognized type
aliases, rather than inserting equivalent notes into three or four places.
regards, tom lane
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
@ 2006-10-03 16:13 ` Andrew Dunstan <[email protected]>
2006-10-03 16:47 ` Re: [HACKERS] timestamptz alias Jim C. Nasby <[email protected]>
1 sibling, 1 reply; 18+ messages in thread
From: Andrew Dunstan @ 2006-10-03 16:13 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: Markus Schaber <[email protected]>; PostgreSQL-development hackers <[email protected]>
Tom Lane wrote:
> Markus Schaber <[email protected]> writes:
>
>> Here's a small patch that adds an appropriate explanation.
>>
>
> If we're going to document these aliases, what of float4, float8, and bool?
> Also, although the docs mention int2/int4/int8, it's more or less left
> to the reader's imagination to deduce what they are.
>
> Perhaps it'd be better to provide a small table of recognized type
> aliases, rather than inserting equivalent notes into three or four places.
>
>
you mean like the table here?
http://momjian.us/main/writings/pgsql/sgml/datatype.html
cheers
andrew
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: [HACKERS] timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-03 16:13 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
@ 2006-10-03 16:47 ` Jim C. Nasby <[email protected]>
2006-10-03 16:57 ` Re: [HACKERS] timestamptz alias Andrew Dunstan <[email protected]>
2006-10-04 00:01 ` Re: [HACKERS] timestamptz alias Peter Eisentraut <[email protected]>
2006-10-04 09:39 ` Re: [HACKERS] timestamptz alias Markus Schaber <[email protected]>
0 siblings, 3 replies; 18+ messages in thread
From: Jim C. Nasby @ 2006-10-03 16:47 UTC (permalink / raw)
To: Andrew Dunstan <[email protected]>; +Cc: Tom Lane <[email protected]>; Markus Schaber <[email protected]>; pgsql-docs
Moving to -docs
On Tue, Oct 03, 2006 at 12:13:46PM -0400, Andrew Dunstan wrote:
> Tom Lane wrote:
> >Markus Schaber <[email protected]> writes:
> >
> >>Here's a small patch that adds an appropriate explanation.
> >>
> >
> >If we're going to document these aliases, what of float4, float8, and bool?
> >Also, although the docs mention int2/int4/int8, it's more or less left
> >to the reader's imagination to deduce what they are.
> >
> >Perhaps it'd be better to provide a small table of recognized type
> >aliases, rather than inserting equivalent notes into three or four places.
> >
> >
>
>
> you mean like the table here?
> http://momjian.us/main/writings/pgsql/sgml/datatype.html
An issue I've seen with the docs is that for chapters that have a lot of
sections (such as 8), the section list at the start of each chapter
fills the screen, so it's easy to miss the fact that there's more info
beneath the list (which is wy presumably most folks never knew that
table existed).
I think the ideal way to handle this would be to put the table of
contents in a side-bar and flow the text around it. But that could be a
real bear to do in docbook/sgml, so perhaps it would be better to just
force the TOC for each chapter onto it's own page (and ensure the
overview/introduction text shows up in the TOC).
--
Jim Nasby [email protected]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: [HACKERS] timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-03 16:13 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-03 16:47 ` Re: [HACKERS] timestamptz alias Jim C. Nasby <[email protected]>
@ 2006-10-03 16:57 ` Andrew Dunstan <[email protected]>
2006-10-04 13:05 ` Re: [HACKERS] timestamptz alias Magnus Hagander <[email protected]>
2 siblings, 1 reply; 18+ messages in thread
From: Andrew Dunstan @ 2006-10-03 16:57 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: Tom Lane <[email protected]>; Markus Schaber <[email protected]>; pgsql-docs
Jim C. Nasby wrote:
> On Tue, Oct 03, 2006 at 12:13:46PM -0400, Andrew Dunstan wrote:
>
>>>
>>> Perhaps it'd be better to provide a small table of recognized type
>>> aliases, rather than inserting equivalent notes into three or four places.
>>>
>>>
>>>
>> you mean like the table here?
>> http://momjian.us/main/writings/pgsql/sgml/datatype.html
>>
>
> An issue I've seen with the docs is that for chapters that have a lot of
> sections (such as 8), the section list at the start of each chapter
> fills the screen, so it's easy to miss the fact that there's more info
> beneath the list (which is wy presumably most folks never knew that
> table existed).
>
> I think the ideal way to handle this would be to put the table of
> contents in a side-bar and flow the text around it. But that could be a
> real bear to do in docbook/sgml, so perhaps it would be better to just
> force the TOC for each chapter onto it's own page (and ensure the
> overview/introduction text shows up in the TOC).
>
I would like a frame driven version of the docs (c.f. doxygen, javadoc,
etc.). The we would not need contents links at the top of each chapter
like this. Navigating the HTML docs is less than pleasant.
Unfortunately, I don't have enough time or docbook-fu to be able to do this.
cheers
andrew
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: [HACKERS] timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-03 16:13 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-03 16:47 ` Re: [HACKERS] timestamptz alias Jim C. Nasby <[email protected]>
2006-10-03 16:57 ` Re: [HACKERS] timestamptz alias Andrew Dunstan <[email protected]>
@ 2006-10-04 13:05 ` Magnus Hagander <[email protected]>
2006-10-04 14:05 ` Re: [HACKERS] timestamptz alias Andrew Dunstan <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: Magnus Hagander @ 2006-10-04 13:05 UTC (permalink / raw)
To: Andrew Dunstan <[email protected]>; Jim C. Nasby <[email protected]>; +Cc: Tom Lane <[email protected]>; Markus Schaber <[email protected]>; pgsql-docs
> I would like a frame driven version of the docs (c.f.
> doxygen, javadoc, etc.). The we would not need contents links
> at the top of each chapter like this. Navigating the HTML
> docs is less than pleasant.
> Unfortunately, I don't have enough time or docbook-fu to be
> able to do this.
Yuck. Frames. Ickk. All the issues with bookmarking and searching and
things like that.
Anyway. If done, make sure the current version doesn't go away, but make
the frames version just an option instead.
//Magnus
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: [HACKERS] timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-03 16:13 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-03 16:47 ` Re: [HACKERS] timestamptz alias Jim C. Nasby <[email protected]>
2006-10-03 16:57 ` Re: [HACKERS] timestamptz alias Andrew Dunstan <[email protected]>
2006-10-04 13:05 ` Re: [HACKERS] timestamptz alias Magnus Hagander <[email protected]>
@ 2006-10-04 14:05 ` Andrew Dunstan <[email protected]>
0 siblings, 0 replies; 18+ messages in thread
From: Andrew Dunstan @ 2006-10-04 14:05 UTC (permalink / raw)
To: Magnus Hagander <[email protected]>; +Cc: Jim C. Nasby <[email protected]>; Tom Lane <[email protected]>; Markus Schaber <[email protected]>; pgsql-docs
Magnus Hagander wrote:
>> I would like a frame driven version of the docs (c.f.
>> doxygen, javadoc, etc.). The we would not need contents links
>> at the top of each chapter like this. Navigating the HTML
>> docs is less than pleasant.
>> Unfortunately, I don't have enough time or docbook-fu to be
>> able to do this.
>>
>
> Yuck. Frames. Ickk. All the issues with bookmarking and searching and
> things like that.
>
> Anyway. If done, make sure the current version doesn't go away, but make
> the frames version just an option instead.
>
>
>
Then use a tiled mechanism instead if you want to avoid frames. Or if
you want to be get more advanced some sort of Ajax solution. But we need
some sort of nav bar that you can drill down on. Navigation now is just
horrible, IMNSHO.
cheers
andrew
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: [HACKERS] timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-03 16:13 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-03 16:47 ` Re: [HACKERS] timestamptz alias Jim C. Nasby <[email protected]>
@ 2006-10-04 00:01 ` Peter Eisentraut <[email protected]>
2 siblings, 0 replies; 18+ messages in thread
From: Peter Eisentraut @ 2006-10-04 00:01 UTC (permalink / raw)
To: Jim C. Nasby <[email protected]>; +Cc: Andrew Dunstan <[email protected]>; pgsql-docs
Jim C. Nasby wrote:
> I think the ideal way to handle this would be to put the table of
> contents in a side-bar and flow the text around it.
It's all CSS, so this should be doable.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: [HACKERS] timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-03 16:13 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-03 16:47 ` Re: [HACKERS] timestamptz alias Jim C. Nasby <[email protected]>
@ 2006-10-04 09:39 ` Markus Schaber <[email protected]>
2 siblings, 0 replies; 18+ messages in thread
From: Markus Schaber @ 2006-10-04 09:39 UTC (permalink / raw)
To: pgsql-docs
Hi, Jim,
Jim C. Nasby wrote:
> An issue I've seen with the docs is that for chapters that have a lot of
> sections (such as 8), the section list at the start of each chapter
> fills the screen, so it's easy to miss the fact that there's more info
> beneath the list (which is wy presumably most folks never knew that
> table existed).
>
> I think the ideal way to handle this would be to put the table of
> contents in a side-bar and flow the text around it. But that could be a
> real bear to do in docbook/sgml, so perhaps it would be better to just
> force the TOC for each chapter onto it's own page (and ensure the
> overview/introduction text shows up in the TOC).
I agree.
The fact that the TOC and the first part of the Chapter are on the same
page has annoyed me several times now. :-)
Regards,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
Attachments:
[application/pgp-signature] signature.asc (252B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
@ 2006-10-04 09:41 ` Markus Schaber <[email protected]>
2006-10-04 14:17 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
1 sibling, 1 reply; 18+ messages in thread
From: Markus Schaber @ 2006-10-04 09:41 UTC (permalink / raw)
To: PostgreSQL-development hackers <[email protected]>
Hi, Tom,
Tom Lane wrote:
>> Here's a small patch that adds an appropriate explanation.
>
> If we're going to document these aliases, what of float4, float8, and bool?
> Also, although the docs mention int2/int4/int8, it's more or less left
> to the reader's imagination to deduce what they are.
>
> Perhaps it'd be better to provide a small table of recognized type
> aliases, rather than inserting equivalent notes into three or four places.
It's not only about documenting the pure existence of the aliases (which
was already documented in the table on the datatype TOC page), it's also
about telling the user which of the names are the ones to avoid, and the
reasons to do so.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
Attachments:
[application/pgp-signature] signature.asc (252B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-04 09:41 ` Re: timestamptz alias Markus Schaber <[email protected]>
@ 2006-10-04 14:17 ` Andrew Dunstan <[email protected]>
2006-10-04 15:52 ` Re: timestamptz alias Markus Schaber <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: Andrew Dunstan @ 2006-10-04 14:17 UTC (permalink / raw)
To: Markus Schaber <[email protected]>; +Cc: PostgreSQL-development hackers <[email protected]>
Markus Schaber wrote:
> It's not only about documenting the pure existence of the aliases (which
> was already documented in the table on the datatype TOC page), it's also
> about telling the user which of the names are the ones to avoid, and the
> reasons to do so.
>
>
>
*blink* Why do any need to be avoided? What you use is a matter of
taste, and your organisation's coding standards. From a purely technical
POV I don't see any reason to avoid using either the canonical type
names or the various aliases.
cheers
andrew
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-04 09:41 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-04 14:17 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
@ 2006-10-04 15:52 ` Markus Schaber <[email protected]>
2006-10-06 02:18 ` Re: timestamptz alias Jim Nasby <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: Markus Schaber @ 2006-10-04 15:52 UTC (permalink / raw)
To: PostgreSQL-development hackers <[email protected]>
Hi, Andrew,
Andrew Dunstan wrote:
>> It's not only about documenting the pure existence of the aliases (which
>> was already documented in the table on the datatype TOC page), it's also
>> about telling the user which of the names are the ones to avoid, and the
>> reasons to do so.
>
> *blink* Why do any need to be avoided? What you use is a matter of
> taste, and your organisation's coding standards. From a purely technical
> POV I don't see any reason to avoid using either the canonical type
> names or the various aliases.
At least compatibility with the SQL standard, as well as with other
Databases might be a reason.
Using pure "timestamp" may lead human readers to be confused, because it
has both meanings with and without timezone historically, this might be
a reason to prefer the "timestamp with[out] time zone" wording.
HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in Europe! www.ffii.org
www.nosoftwarepatents.org
Attachments:
[application/pgp-signature] signature.asc (252B, 2-signature.asc)
download
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-04 09:41 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-04 14:17 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-04 15:52 ` Re: timestamptz alias Markus Schaber <[email protected]>
@ 2006-10-06 02:18 ` Jim Nasby <[email protected]>
2006-10-06 07:35 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: Jim Nasby @ 2006-10-06 02:18 UTC (permalink / raw)
To: Markus Schaber <[email protected]>; +Cc: PostgreSQL-development hackers <[email protected]>
On Oct 4, 2006, at 10:52 AM, Markus Schaber wrote:
> Andrew Dunstan wrote:
>>> It's not only about documenting the pure existence of the aliases
>>> (which
>>> was already documented in the table on the datatype TOC page),
>>> it's also
>>> about telling the user which of the names are the ones to avoid,
>>> and the
>>> reasons to do so.
>>
>> *blink* Why do any need to be avoided? What you use is a matter of
>> taste, and your organisation's coding standards. From a purely
>> technical
>> POV I don't see any reason to avoid using either the canonical type
>> names or the various aliases.
>
> At least compatibility with the SQL standard, as well as with other
> Databases might be a reason.
It would be nice to denote types/aliases that are and aren't ANSI. A
number are marked in the docs, but it would be good to add the info
to that summary table.
--
Jim Nasby [email protected]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
--
Jim Nasby [email protected]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-04 09:41 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-04 14:17 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-04 15:52 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-06 02:18 ` Re: timestamptz alias Jim Nasby <[email protected]>
@ 2006-10-06 07:35 ` Andrew Dunstan <[email protected]>
2006-10-08 17:03 ` Re: timestamptz alias Jim C. Nasby <[email protected]>
0 siblings, 1 reply; 18+ messages in thread
From: Andrew Dunstan @ 2006-10-06 07:35 UTC (permalink / raw)
To: Jim Nasby <[email protected]>; +Cc: PostgreSQL-development hackers <[email protected]>
Jim Nasby wrote:
>
> It would be nice to denote types/aliases that are and aren't ANSI. A
> number are marked in the docs, but it would be good to add the info
> to that summary table.
Right under the table this sentence appears:
Compatibility: The following types (or spellings thereof) are specified
by SQL: bit, bit varying, boolean, char, character varying, character,
varchar, date, double precision, integer, interval, numeric, decimal,
real, smallint, time (with or without time zone), timestamp (with or
without time zone).
What's unclear about that?
cheers
andrew
^ permalink raw reply [nested|flat] 18+ messages in thread
* Re: timestamptz alias
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` Re: timestamptz alias AgentM <[email protected]>
2006-10-03 01:26 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-03 09:20 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-03 15:33 ` Re: timestamptz alias Tom Lane <[email protected]>
2006-10-04 09:41 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-04 14:17 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
2006-10-04 15:52 ` Re: timestamptz alias Markus Schaber <[email protected]>
2006-10-06 02:18 ` Re: timestamptz alias Jim Nasby <[email protected]>
2006-10-06 07:35 ` Re: timestamptz alias Andrew Dunstan <[email protected]>
@ 2006-10-08 17:03 ` Jim C. Nasby <[email protected]>
0 siblings, 0 replies; 18+ messages in thread
From: Jim C. Nasby @ 2006-10-08 17:03 UTC (permalink / raw)
To: Andrew Dunstan <[email protected]>; +Cc: Jim Nasby <[email protected]>; PostgreSQL-development hackers <[email protected]>
On Fri, Oct 06, 2006 at 02:35:55AM -0500, Andrew Dunstan wrote:
> Jim Nasby wrote:
> >
> > It would be nice to denote types/aliases that are and aren't ANSI. A
> > number are marked in the docs, but it would be good to add the info
> > to that summary table.
>
> Right under the table this sentence appears:
>
> Compatibility: The following types (or spellings thereof) are specified
> by SQL: bit, bit varying, boolean, char, character varying, character,
> varchar, date, double precision, integer, interval, numeric, decimal,
> real, smallint, time (with or without time zone), timestamp (with or
> without time zone).
>
> What's unclear about that?
Oops. This is what happens when I answer emails on a plane. :(
--
Jim Nasby [email protected]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
^ permalink raw reply [nested|flat] 18+ messages in thread
end of thread, other threads:[~2006-10-08 17:03 UTC | newest]
Thread overview: 18+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-10-02 22:15 timestamptz alias Markus Schaber <[email protected]>
2006-10-02 22:22 ` AgentM <[email protected]>
2006-10-03 01:26 ` Jim Nasby <[email protected]>
2006-10-03 09:20 ` Markus Schaber <[email protected]>
2006-10-03 15:33 ` Tom Lane <[email protected]>
2006-10-03 16:13 ` Andrew Dunstan <[email protected]>
2006-10-03 16:47 ` Jim C. Nasby <[email protected]>
2006-10-03 16:57 ` Andrew Dunstan <[email protected]>
2006-10-04 13:05 ` Magnus Hagander <[email protected]>
2006-10-04 14:05 ` Andrew Dunstan <[email protected]>
2006-10-04 00:01 ` Peter Eisentraut <[email protected]>
2006-10-04 09:39 ` Markus Schaber <[email protected]>
2006-10-04 09:41 ` Markus Schaber <[email protected]>
2006-10-04 14:17 ` Andrew Dunstan <[email protected]>
2006-10-04 15:52 ` Markus Schaber <[email protected]>
2006-10-06 02:18 ` Jim Nasby <[email protected]>
2006-10-06 07:35 ` Andrew Dunstan <[email protected]>
2006-10-08 17:03 ` Jim C. Nasby <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox