[GENERAL] Get closest numbers between intervals

Hi, I have one table that has this structure: city_code, start_ip, end_ip I´m searching for the city that its between two ip´s. But, i would like to get the nearest´s cities too. Any ideas how can i search for the city proximity? thanks! -- Sent via pgsql-general mailing list (pgsql-gener

[GENERAL] Creating index for convert text to integer

Hi, How can i create a index to index all the fields that has the type INTEGER, in the following table: create type properties_types as enum('INTEGER', 'STRING', 'FLOAT'); create table properties_types( value text NOT NULL, value_type properties_types NOT NULL ); insert into properties_

Re: [GENERAL] Improving Full text performance

...because i have no root pass to my server. On 22 ago, 02:20, o...@sai.msu.su (Oleg Bartunov) wrote: > On Fri, 21 Aug 2009, xaviergxf wrote: > > Hi, > > >   I?m using php and full text on postgresql 8.3 for indexing html > > descriptions. I have no acess to postgres

[GENERAL] Improving Full text performance

Hi, I´m using php and full text on postgresql 8.3 for indexing html descriptions. I have no acess to postgresql server, since i use a shared hosting service. To improve search and performance, i want to do the follow: Strip all html tags then use my php script to remove more stop words (b

[GENERAL] TSearch2 Searching Text with Synonyms and Stop Dictionary

Hi, I´m trying to use the tsearch2 with postgre 8.2. What i am trying to do its: from a text search the text and synonyms excluding the words that doesn´t mean nothing like("what", "the", "of"). How can i configure the dictionarys for use both synonyms and stop dictionarys? Can anyone creat

[GENERAL] Postgresql installation - cannot initdb 1

Hi, I had the postgresql version 8.2, but i´ve updated it to the 8.3. During the installation, postresql show this message "Failed to run initdb: 1". I already tried to remove and reinstall, but it does not works. Did anyone know how can i solve this problem? Thanks -- Sent via pgsql-general m

Re: [GENERAL] Table with differerent Data Types

hi, i haven´t found the explication about my problem... On 24 abr, 03:04, [EMAIL PROTECTED] (Klint Gore) wrote: > xaviergxf wrote: > > Hi, > > >    I´m trying to do the follow: create a table like: > > create table t( > >   cod serial, > >   data_type char

[GENERAL] Table with differerent Data Types

Hi, I´m trying to do the follow: create a table like: create table t( cod serial, data_type char(10), value ??? ); I would like to do the follow the table would tell me what data type its the value. For instance: insert into t values(1, 'Integer', 12); insert into t values(2, 'String',