soundex error

[Doug Barger]

select description,soundex(description) as sx from
parts
this generates the following error
<<<<<<<<<<<<<<<<<<<<<<<<
[LNA][Pervasive][ODBC Engine Interface]Error in expression: soundex ( description )
>>>>>>>>>>>>>>>>>>>>>>>>

 

[mirtheil]

What version of PSQL are you using? The soundex wasn't introduced until PSLQ v10. Also, what data type is the "description"? Does this query work against the DEMODATA database?

select description, soundex(description) from course

I tested it using PSQL v11 and got a result set.


Mirtheil

http://www.mirtheil.com