Thread: 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/ > 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.
Attachment
> <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/ > 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.
Attachment
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/ > 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.