DB[:rates].where(:prefix => substring('number', 1, length(prefix)).first

Rather.

On Wed, Oct 14, 2009 at 8:28 AM, Diego Viola <diego.viola@gmail.com> wrote:
Nice, I just converted this to Ruby/Sequel.

DB[:rates].first{{prefix=>substring('number', 1, length(prefix))}}

Thanks for the help :).


On Wed, Oct 14, 2009 at 2:07 AM, TTNC - Adnan Barakat <technical@ttnc.co.uk> wrote:
Diego Viola wrote:
> I'm using MySQL now but I will try PostgreSQL with the prefix module, is
> there a way to do that without the prefix module and with regular SQL?
>
> Any examples?
SELECT * FROM rates WHERE prefix = SUBSTRING('$NUMBER$', 1,
LENGTH(prefix)) LIMIT 1

Adnan

> Diego
>
> On Tue, Oct 13, 2009 at 10:45 PM, Even André Fiskvik <grevenx@me.com
> <mailto:grevenx@me.com>> wrote:
>
>     What database are you using?
>     You could do this with regular SQL, but it would by a costly operation,
>     for PostgreSQL we're using the prefix module:
>     http://pgfoundry.org/projects/prefix/
>
>     You can then match the closest prefix by using something like
>     "WHERE myprefix_col @> caller_destination_number ORDER BY LENGTH
>     (myprefix_col::text) LIMIT 1;"
>
>
>     Best regards,
>     Even André
>
>
>     On 13. okt. 2009, at 23.53, Diego Viola wrote:
>
>     > Hello,
>     >
>     > I'm trying to write a post-paid billing script, I have the CDR on my
>     > database and also a "rates" table, the CDR contains fields like
>     > caller_destination_number, variable_duration, etc. and the rates
>     > table contains: destination, prefix, rate (cost).
>     >
>     > The problem is that I can't just strip the destination number to
>     > take the prefix from it because I have to deal with destination
>     > numbers from different countries and they all have different prefix
>     > lengths... so I need to find another way to take the prefix from the
>     > destination number.
>     >
>     > Any ideas how to do this?
>     >
>     > Thanks,
>     >
>     > Diego
>     >
>     > _______________________________________________
>     > FreeSWITCH-users mailing list
>     > FreeSWITCH-users@lists.freeswitch.org
>     <mailto:FreeSWITCH-users@lists.freeswitch.org>
>     > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>     > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-
>     > users
>     > http://www.freeswitch.org
>
>
>     _______________________________________________
>     FreeSWITCH-users mailing list
>     FreeSWITCH-users@lists.freeswitch.org
>     <mailto:FreeSWITCH-users@lists.freeswitch.org>
>     http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>     UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>     http://www.freeswitch.org
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users@lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org


_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org