Re: [GENERAL] Arrays with Rails?

2007-04-13 Thread Alexander Presber
Listmail schrieb: Then, other languages will make you feel the pain of having to quote all your arguments YOURSELF and provide all results as string. The most famous offender is PHP (this causes countless security holes). I partially did this for PHP. It's a lifesaver. No more addsl

[GENERAL] printf-like format strings

2007-01-22 Thread Alexander Presber
Hello, does somebody know of an extension for postgres that allows the use of printf-like format strings? PL/Perl comes to mind, but how could one take care of the variable argument count? Thanks for any advice! Sincerely Alexander Presber ---(end of broadcast

[GENERAL] Functional Index

2006-11-22 Thread Alexander Presber
me=0.036..3300.961 rows=77577 loops=1) Filter: (lower((main_subject)::text) ~~ '10%'::text) Total runtime: 3421.751 ms (4 Zeilen) Am I misunderstanding the concept of functional indexes? Is there another way to achieve Any help is greatly appreciated. Yours, Alexander Presber beg

Re: [GENERAL] TSearch2 / German compound words / UTF-8

2006-02-17 Thread Alexander Presber
#x27;,'overtrekkgrill'); lexize {over,trekk,grill,overtrekk,grill} (1 Zeile) It simply doesn't work. No UTF-8 is involved. Sincerely yours, Alexander Presber P.S.: Henning: Sorry for bothering you with the CC, just ignore it, if you like. Am 27.01.2006 um

[GENERAL] referential integrity without trigger

2006-02-09 Thread Alexander Presber
orrupted. Is there a clever, general scheme to "recheck" and enforce foreign key contraints, after the responsible triggers have been disabled and reenabled? I hope this makes sense to you. Alexander Presber ---(end of broadcast)

Re: [GENERAL] TSearch2 / German compound words / UTF-8

2006-01-27 Thread Alexander Presber
(german,lword,"Latin word",vertrags,"{ispell_de,simple}",'vertrag') (1 Zeile) The affix is just not applied while looking for compound words. Sincerely yours Alexander Presber ---(end of broadcast)--- TIP

Re: [GENERAL] TSearch2 / German compound words / UTF-8

2006-01-27 Thread Alexander Presber
Tsearch/isepll is not able to break this word into parts, because of the "s" in "Produktion/s/intervall". Misspelling the word as "Produktionintervall" fixes it: It should be affixes marked as 'affix in middle of compound word', Flag is '~', example look in norsk dictionary: flag ~\\: [^S

[GENERAL] Errors with temporary tables

2005-11-24 Thread Alexander Presber
hes.tables WHERE name='tmp_c7470136936abaa8322358ad4905e5a3'; COMMIT; --- DB Error: unknown error ERROR: tuple concurrently updated --- What does that mean? How can we avoid this error? In reality we encountered these two errors directly one after the other and in reversed order, so

Re: [GENERAL] Tsearch2: casting text to tsquery

2005-11-16 Thread Alexander Presber
Am 16.11.2005 um 13:52 schrieb Oleg Bartunov: On Wed, 16 Nov 2005, Alexander Presber wrote: Hello, I have a question that arose while using tsearch on a large database of book information. In order to inject unstemmed + stemmed versions of searchstrings into a query we want to cast an

[GENERAL] Tsearch2: casting text to tsquery

2005-11-16 Thread Alexander Presber
y How can we work around that? Thanks for any help Sincerely yours Alexander Presber ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] unsubscribe

2005-10-21 Thread Alexander Presber
unsubscribe ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster