[GENERAL] problems with function pg_catalog.btrim(date)

Hi everybody, I hope some one can help me, I have created the following function but I always get the error that there is not function pg_catalog.btrim(date), in the version postgresql 8.1 it worked but now it does not so I don't know if it is related with a configuration problem of the post

[GENERAL] problems with encoding

Hi, I have a Map info file named map.TAB and when I tried to export it to Postgres I get an error of encoding so I used konwert to convert it to utf8 using the following statement konwert any/es-utf8 map.TAB -O But this only convert the name of the header of each column but not the registers of e

[GENERAL] problems with special characters

Hi list, I have a problem I have created a database with encoding SQL_ASCII and when I insert the data using a terminal in linux and insert the data for example Insert into mytable values(1,'Eléctrico'); it works fine but if I try to copy this data from a text file doing \copy mytable from tex

[GENERAL] find a string contained in an attribute

Hi, I want to know if it is possible to search for a string of characters inside an attribute for example I have the following table and values cod_unidad | nombre_uni +- 1 | Facultad de Ciencias Naturales y Matemát

Re: [GENERAL] find a string contained in an attribute

Thanks a lot for your help that's exactly what I wanted. It worked fine. regards, karina On Wed, Mar 24, 2010 at 3:25 PM, Szymon Guz wrote: > 2010/3/24 Karina Guardado > > Hi, >> >> I want to know if it is possible to search for a string of characters >> i

[GENERAL] data type to store a lot of text and tables of data

Hi, Is there a special data type to use to store a lot of text and tables of data in a column or attribute? thanks in advance, regards, karina El Salvador, Centroamerica

Re: [GENERAL] data type to store a lot of text and tables of data

l '1 second'interval '00:15:00' * 21 * interval '1 day'interval '21 days' * double precision '3.5' * interval '1 hour'interval '03:30:00' / interval '1 hour' / double precision '1.5'interval '00:40:00'

Re: [GENERAL] data type to store a lot of text and tables of data

, Mar 24, 2010 at 4:08 PM, Raymond O'Donnell wrote: > On 24/03/2010 22:01, Karina Guardado wrote: > > > what should be the data type to store a file that can be xls, doc, pdf > > for example. > > Sorry, I missed this bit - for binary files you can use the bytea ty

Re: [GENERAL] data type to store a lot of text and tables of data

Thank you very much for your help and so soon answears. I will try using the solutions you suggest. best regards, karina On Wed, Mar 24, 2010 at 4:44 PM, Raymond O'Donnell wrote: > On 24/03/2010 22:39, Karina Guardado wrote: > > You know I need to design a table where some att

Re: [GENERAL] find a string contained in an attribute

Do you have a link where I can read more about this because is not easy to understand. Thanks for your help, karina On Thu, Mar 25, 2010 at 1:34 AM, Pavel Stehule wrote: > 2010/3/24 Szymon Guz : > > 2010/3/24 Karina Guardado > >> > >> Hi, > >> > >&g