Hoping that perhaps someone here has already been down this road and may be
willing to provide some pointers.
Can anyone direct me to information regarding the use of PostgreSQL with other
references to verify/flag bad telephone number data?
I've tables with 'people' data ( f/lname, addr, zip, telno, etc ). I know that some of the records have invalid telno's ( no area
code, transposed area code or transposed exchange digits, etc ) -- I'm looking for methods/means of identifying them, for example,
'..we've used Company X's product to validate area code and exchange against zipcode/state...', '...this contrib/addon should
help...', '..I used http://blah.blah.com as a reference for this...', '...using software/site/data provided by X you can automate
the lookup and validation of person/telno against person/telno in DB...', etc.
Please advise if there's a more appropriate forum for this also ( I realize that more appropriate may be more general than
PostgreSQL; at the same time I think this might be a position that many PostgreSQL users might find themselves facing so may be on
topic enough to warrant the email archives).
Thanks,
reid
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
