Received: from send204.yahoomail.com (send204.mail.yahoo.com [128.11.68.128]) by hub.org (8.9.1/8.9.1) with SMTP id OAA09899 for ; Thu, 21 Jan 1999 14:40:27 -0500 (EST) (envelope-from peter_garner@yahoo.com) Message-ID: <19990121193638.17311.rocketmail@send204.yahoomail.com> Received: from [208.19.232.135] by send204.mail.yahoo.com; Thu, 21 Jan 1999 11:36:38 PST Date: Thu, 21 Jan 1999 11:36:38 -0800 (PST) From: Peter Garner Subject: Re: [SQL] Max Length of SQL To: tim@dmcity.net, pierre@desertmoon.com, pgsql-sql@hub.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Hi Tim, I might be interested in collaborating as I am presently writing an offline reader that gets NNTP news and puts it in postgres. (I have already done this in C++ but I want to port it to Java.) If nothing else, you are welcome to the C++ code. Word of warning, I have been doing C++ for 11 years but this is my first attempt at Java! :-) Another word of warning, :-) I am an itinerant consultant and I tend to get called off to work in the middle of personal projects like this! :-) Right now my C++ program uses LOBs. I think Herouz is right, however. She suggested splitting >8K fields into multiple text fields. E.g. you would have a table (for nntp news) like : create table MsgBodies ( MsgId Text , ChunkNumber int , MsgBody Text , primary key (MsgId , ChunkNumber) ) ; The majority of nntp msgs would just have one entry, but a few would be split into two or more entries. ---Tim Perdue wrote: >that it can talk to NNTP servers too >(any volunteers????). == Peace, Peter We are Microsoft of Borg, you will be assimilated! Resistance is fut... *BZZRRT* General Protection Fault in MSBorg32.DLL, Please contact the vendor of this Borg for more information _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com