Received: from send102.yahoomail.com (send102.yahoomail.com [205.180.60.90]) by hub.org (8.9.1/8.9.1) with SMTP id LAA18035 for ; Thu, 21 Jan 1999 11:06:47 -0500 (EST) (envelope-from tim_perdue@yahoo.com) Message-ID: <19990121160844.22291.rocketmail@send102.yahoomail.com> Received: from [204.167.169.69] by send102.yahoomail.com; Thu, 21 Jan 1999 08:08:44 PST Date: Thu, 21 Jan 1999 08:08:44 -0800 (PST) From: Tim Perdue Reply-To: tim@dmcity.net Subject: Re: [SQL] Max Length of SQL To: pierre@desertmoon.com, pgsql-sql@hub.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii I will open-source it and write an article explaining how it works on my PHPBuilder.com web site. It needs to be further debugged right now, and I am expanding it so that it can talk to NNTP servers too (any volunteers????). --Tim ---pierre@desertmoon.com wrote: > > This sounds very cool....any chance of open sourcing it? So that those of us > who lack your most incredible skill can make use of it? > > -=pierre > > > > > I've written a Java program that runs every so often (by Cron), then grabs > > the email, slices and dices it and drops it into PGSQL. > > > > It's pretty cool. > > > > I'm not sure I understand BLOBS - are they indexable (ie fast searches) and > > are they stored inside the table? > > > > Is the example you gave appropriate for storing text? (looks like graphics?) > > > > Tim > > > > > > > > -----Original Message----- > > From: Fabrice Scemama > > To: Tim Perdue, The Des Moines City.net > > Date: Thursday, January 21, 1999 6:29 AM > > Subject: Re: [SQL] Max Length of SQL > > > > > > >"Tim Perdue, The Des Moines City.net" wrote: > > >> > > >> I'm started to run into a situation where my SQL statements are too long > > >> (I'm archiving a mailing list into a Postgres table). > > >> > > >> What is the max length of a Text field in PostgreSQL? Suggestions for > > >> working around this besides large objects? > > >> > > >> Tim > > > > > >The maximal lenght is 8192 cars. > > >You might need BLOBs instead. Here's an example : > > > > > > create table image (name text, raster oid); > > > insert into image (name, raster) values ('fichier', \ > > > lo_import('/etc/motd')); > > > select lo_export(image.raster, '/tmp/motd') from image \ > > > where name = 'fichier'; > > > > > >Hope it helps. > > >BTW, using Pg to store Mailing lists emais seems interesting. > > >Do you have a daemon that gets the mails, then parse them and > > >populate the DB with them ?... > > > > > >Fabrice > > > > > > > > > > > == ______________________________________________________ Directricity.com - Get local! http://directricity.com/ _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com