Hi Michal,
I am still attempting to make sqlbill work. The diffence between your
sample voiptariffdst/voiptariff and mine is in the prefix where for
example, my prefix=1 while in the sample, it is 001 for the USA. I have
edited that prefix in the table to reflect 1 instead of 001 but it still
would not compute the price. I then simulated the query and below is the
result:
select * from voiptariffdst where active and
ascii(prefix)=ascii('19017154800') and ('19017154800' like (prefix ||
''%'')) limit 1;
And got this result:
ERROR: operator is not unique: "unknown" % "unknown"
HINT: Could not choose a best candidate operator. You may need to add
explicit type casts.
I changed the query to:
select * from voiptariffdst where active and
ascii(prefix)=ascii('19017154800') and ('19017154800' like (prefix ||
'%')) limit 1;
And got :
id | active | prefix | description
----+--------+--------+-------------
57 | t | 1 | USA
(1 row)
It appears that the double single quote near the % was creating an error
in match_tariff.
Is my finding correct?
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________________
List: Openh323gk-users@xxxxxxxxxxxxxxxxxxxxx
Archive: http://sourceforge.net/mailarchive/forum.php?forum_id=8549
Homepage: http://www.gnugk.org/
