Re: [GENERAL] Fwd: row_to_json() with numerical indices in stead of associative indices

2013-12-01 Thread Tjibbe
I had tried something similar, but it is not possible because: ERROR: PL/pgSQL functions cannot accept type record So it would be nice that in version postgresql 9.4 this parameter is added to the function row_to_json. Maybe RECORD as INPUT parameter is allowed in other procedural languages lik

[GENERAL] Searching for suiting index

2013-12-01 Thread Janek Sendrowski
Hi,   I store around 300 bits the row in my table. Every bit is a boolean values on its own. I want to do a similarity search by comparing each bit and get every row which has a certain number of equal bits. What kind of index could be useful for scenario? Could it make sense to calculate a kind