5 new entries for FAQ
[Sorry for the duplicate post, sent to wrong list first time]
Hi,
After going through pgsql-general a bit I figured there were a few
important questions missing from the FAQ, so I wrote some.
Comments welcome. I can write more, if people can suggest things to
write about. I was thinking something about collation and locales but
I'm sure sure I understand them myself.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
Attachments:
FAQ.html.1.patchtext/plain; charset=us-asciiDownload+114-1
<P>If you're really desparate, you can increase the pagesize a bit (to
Should be "desperate," not "desparate."
On Wed, 2005-08-10 at 04:04, Martijn van Oosterhout wrote:
[Sorry for the duplicate post, sent to wrong list first time]
Hi,
After going through pgsql-general a bit I figured there were a few
important questions missing from the FAQ, so I wrote some.Comments welcome. I can write more, if people can suggest things to
write about. I was thinking something about collation and locales but
I'm sure sure I understand them myself.
I might suggest adding links to the relevant portions of the docs, for
example add a link to
http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
On Wed, Aug 10, 2005 at 10:04:23AM +0200, Martijn van Oosterhout wrote:
Comments welcome. I can write more, if people can suggest things to
write about. I was thinking something about collation and locales but
I'm sure sure I understand them myself.
I'd really love to see a Q&A for encodings, recoding, and "I see strange
characters." Not sure how to phrase the question though.
--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Java is clearly an example of a money oriented programming" (A. Stepanov)
On Wed, Aug 10, 2005 at 11:17:40AM -0400, Alvaro Herrera wrote:
On Wed, Aug 10, 2005 at 10:04:23AM +0200, Martijn van Oosterhout wrote:
Comments welcome. I can write more, if people can suggest things to
write about. I was thinking something about collation and locales but
I'm sure sure I understand them myself.I'd really love to see a Q&A for encodings, recoding, and "I see strange
characters." Not sure how to phrase the question though.
I think you could write a whole section just on them and all the issues
on various platforms. But having never dealt with a system with
multiple languages / encodings I'm not sure I really understand the
issues. You know, like:
Encoding / character sets gotchas / recommendations:
Languages:
Asian
European
Programming:
Perl
Python
Java
ODBC
Regular expressions
Full text indexing
etc...
Platforms:
Windows
UNIX
etc...
The main thing I wonder about is does UTF-8 handle all characters
anybody would want to use. I've been told it doesn't for Asian
languages, in which case I don't see how this is a solvable problem
anyway.
I've collected quite a few comments from other people, so I'll post a
slightly revised patch later.
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.
On Wed, Aug 10, 2005 at 10:04:22AM +0200, Martijn van Oosterhout wrote:
After going through pgsql-general a bit I figured there were a few
important questions missing from the FAQ, so I wrote some.
Given the additions to the FAQ and suggestions made by Bruce about how
often the questions come up, I've decided to withdraw this patch.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
tool for doing 5% of the work and then sitting around waiting for someone
else to do the other 95% so you can sue them.