[Freeswitch-users] Some help with my post-paid billing project

[Diego Viola]

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?

Diego

On Tue, Oct 13, 2009 at 10:45 PM, Even André Fiskvik <grevenx at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091014/13376e9f/attachment-0002.html