Re: [GENERAL] Max Length for VARCHAR?
How about: TEXT Relevant section in the users guide: http://www.postgresql.org/docs/user/datatype965.htm Chris Gokey wrote: > > Hi everyone, > > What is the maximum length of VARCHAR? If there something equivalent > to Oracle's LONG in postgresql? I need a datatype that can hold very > large text? > > Chris > > -- > Christopher D. Gokey, Raytheon ITSS, NASA/GCMD > 18 Martin Road, Shelburne Falls, MA 01370 > Phone: Voice (413) 625-8129 / FAX 208-248-9055 > [EMAIL PROTECTED] / http://gcmd.nasa.gov
[GENERAL] storing large amounts of text
I'm sure this has come up before because it just logically seems like others would have run up against this too. Is it possible to store a large amount of text in a row/field? I want to store articles in the database along with information about them, sort of a content databasing system. Can anyone reccommend a good way to go about doing this in Postgres? Any and all help greatly appreciated. --Paul
Re: [GENERAL] storing large amounts of text
I thought TEXT had a limit of 8K or something around that size, I would need something larger. Stephan Richter wrote: > > At 08:19 PM 4/22/00 +, Paul Dlug wrote: > >I'm sure this has come up before because it just logically seems like > >others would have run up against this too. Is it possible to store a > >large amount of text in a row/field? I want to store articles in the > >database along with information about them, sort of a content databasing > >system. Can anyone reccommend a good way to go about doing this in > >Postgres? Any and all help greatly appreciated. > > The TEXT type will help you or do you look for something else? > > CREATE TABLE foo ( > id int8, > content text); > > Regards, > Stephan > -- > Stephan Richter - (901) 573-3308 - [EMAIL PROTECTED] > CBU - Physics & Chemistry; Framework Web - Web Design & Development > PGP Key: 735E C61E 5C64 F430 4F9C 798E DCA2 07E3 E42B 5391
Re: [GENERAL] Zip Code Proximity
Does anyone happen to have a copy of the zips.zip file from the census bureau? Their FTP server is uncooperative. Dustin Sallings wrote: > > On Thu, 18 May 2000, Jeff Hoffmann wrote: > > I tried to get a few permutations of that to work, but with no > luck. The following will give a list of all places sorted by how far away > from my house they are: > > select zipcode, city, state, point(latitude, longitude) as point > from zips > order by point_distance(location_of(95051), point(latitude,longitude)) > > I defined the function location_of for my own convenience: > > create function location_of(integer) returns point as > 'select point(latitude, longitude) from zips where zipcode = $1 ' > language 'sql' > > # > select zip, location <@> '(lat, lon)'::box > # > from zipcodes > # > order by location <@> '(lat, lon)'::box > # > limit 10; > # > > # > # oops, typo. those boxes should be points. plus, it looks like you can > # get zipcodes & lat-longs from the census at: > # > # http://ftp.census.gov/geo/www/gazetteer/places.html > # > # > > -- > dustin sallingsThe world is watching America, > http://2852210114/~dustin/ and America is watching TV. -- Paul Dlug Unix/Web Programmer
