Re: [GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread Sukuchha Shrestha
Hi Pavel, Thanks for your code. I am using postgresql 8.3 so dont have unnest function in my postgresql. But i found equivalend code for unnest in internet. Afterwards i tried your code, and it worked !! Thanks for the help ! you saved me from being a dead man. Sukuchha

[GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread Sukuchha Shrestha
is much apprecieated ! Sukuchha

[GENERAL] Connecting matlab with postgresql

2011-04-29 Thread Sukuchha Shrestha
database toolbox. Could anybody explain here how to connect in a detailed step ! Consider me studying in class 1 of postgresql when explaining :) Sukuchha

[GENERAL] load sql from the file in postgresql

2011-04-29 Thread Sukuchha Shrestha
C:\psql\ therefore i tried to call the loaddata.sql in psql like \i C:\psql\loaddata.sql But it says " C:: Permission denied" What is a problem ? Please guide me ! Is there any better way to call copy commad in a loop with varying filename! regards Sukuchha

[GENERAL] Multilingual full text indexing

2010-12-13 Thread Sukuchha
I have a table ( named test) with following strucuture ID, lang, Name, Name_en, Name_de http://postgresql.1045698.n5.nabble.com/file/n3303131/Capture.jpg I want to do a full text seach on the table. I can create a ts_vector and store in another column by gin_tsvector = tsvector('de', Titel_de