On Apr 12, 2014, at 5:27 PM, Chris McCann <[email protected]> wrote:

> But Postgres does not appear to support the <-> distance operator between 
> text values or integer arrays.  The code example in that SO post does not 
> work, though the author doesn't claim that it does.

Read the section on Postgres indexing. I believe you can use a custom distance 
operator you define yourself.

Postgres has two custom index options; one is faster on insert and one is 
faster on lookup.

Regards,

Guyren G Howe
Relevant Logic LLC

guyren-at-relevantlogic.com ~ http://relevantlogic.com ~ +1 512 784 3178

Ruby/Rails,  Xojo, PHP programming
PostgreSQL, MySQL database design and consulting
Technical writing and training

Read my book, Real OOP with REALbasic: 
<http://relevantlogic.com/oop-book/about-the-oop-book.php>

-- 
-- 
SD Ruby mailing list
[email protected]
http://groups.google.com/group/sdruby
--- 
You received this message because you are subscribed to the Google Groups "SD 
Ruby" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to