Re: [GENERAL] id and ID in CREATE TABLE

From: Thomas Swan <tswan(at)idigx(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: stefan(at)extum(dot)com, Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] id and ID in CREATE TABLE
Date: 2002-07-19 15:39:32
Message-ID: 3D3832B4.2090205@idigx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title></title>
</head>
<body>
Tom Lane wrote:<br>
<blockquote type="cite" cite="mid12220(dot)1027085465(at)sss(dot)pgh(dot)pa(dot)us">
<pre wrap=""><a class="moz-txt-link-abbreviated" href="mailto:stefan(at)extum(dot)com">stefan(at)extum(dot)com</a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">But anyway this is not so important, but why upper cases are bad ?
</pre>
</blockquote>
<pre wrap=""><!---->
It's well established that all-lower-case text is more readable than
all-upper-case ... at least in English; but I think the same would be
true of any language using an approximately Roman alphabet. The problem
with upper case is there's less variation in the overall letter shape.
If you don't care to dig in the academic literature about it, here's a
simple experiment: which of the following paragraphs do you find more
readable?

it's well established that all-lower-case text is more readable
than all-upper-case ... at least in english; but i think the
same would be true of any language using an approximately roman
alphabet. the problem with upper case is there's less variation
in the overall letter shape. if you don't care to dig in the
academic literature about it, here's a simple experiment: which
of the following paragraphs do you find more readable?

IT'S WELL ESTABLISHED THAT ALL-LOWER-CASE TEXT IS MORE READABLE
THAN ALL-UPPER-CASE ... AT LEAST IN ENGLISH; BUT I THINK THE
SAME WOULD BE TRUE OF ANY LANGUAGE USING AN APPROXIMATELY ROMAN
ALPHABET. THE PROBLEM WITH UPPER CASE IS THERE'S LESS VARIATION
IN THE OVERALL LETTER SHAPE. IF YOU DON'T CARE TO DIG IN THE
ACADEMIC LITERATURE ABOUT IT, HERE'S A SIMPLE EXPERIMENT: WHICH
OF THE FOLLOWING PARAGRAPHS DO YOU FIND MORE READABLE?

For me, at least, the second version takes noticeably more time to read
and is certainly less pleasant. (I suppose that for a non-native
speaker of English, mental translation might slow you down to the point
where you don't notice a difference. If so, try it on a random
paragraph in your own language.)</pre>
</blockquote>
It's a pattern recognition issue.&nbsp;&nbsp; Taken in context with your reading experience
and the general constructs of the English language in addition common usage,
you encounter far more lower case letters than upper case letters.&nbsp; It makes
sense that it would be easier to recognize the words in all lower case.&nbsp;
Secondly, your brain expects lower case letters behind the leading upper
case letter for the word.&nbsp;&nbsp; So in a sense you backtrack just a little because
it doesn't match what you expect.&nbsp;&nbsp; I'm not discounting the statements you
made, but this is one additional observation.<br>
<br>
[ In the previous paragraph there were 6 capital letters to the 471 non-capital
letters. ]<br>
<blockquote type="cite" cite="mid12220(dot)1027085465(at)sss(dot)pgh(dot)pa(dot)us">
<pre wrap="">

For PostgreSQL there is also a backwards compatibility issue: if we
change this decision now, we'd cause all kinds of problems for existing
code and databases.

</pre>
<blockquote type="cite">
<pre wrap="">Why then Oracle , IBM is using them and why the SQL standard is not
changed ?
</pre>
</blockquote>
<pre wrap=""><!---->
The SQL standard's choice in this matter is prehistoric; undoubtedly
it falls out of the days when computer printers only had one type case.
IBM probably still has a residual fondness for those days ;-). But
the rest of the industry figured out that lower case was better
somewhere around 1960, cf Algol-60 which was the first language to spell
its keywords preferentially in lower case.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

<a class="moz-txt-link-freetext" href="http://www.postgresql.org/users-lounge/docs/faq.html">http://www.postgresql.org/users-lounge/docs/faq.html</a>
</pre>
</blockquote>
<br>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 3.9 KB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-19 15:40:24 Re: COMMIT in PostgreSQL
Previous Message Tom Lane 2002-07-19 15:38:10 Re: Linux max on shared buffers?

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2002-07-19 16:33:59 Two Index Questions
Previous Message Bruce Momjian 2002-07-19 15:36:19 Re: [SQL] id and ID in CREATE TABLE