Warning: pg_query() [function.pg-query]: Query failed: ERROR: function toupper(text) does not exist LINE 2: WHERE SUBSTRING(TOUPPER(name) FROM 1 FOR 1) NOT IN ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. in /home/sites/bar/drink_browser.php on line 225
ERROR: function toupper(text) does not exist LINE 2: WHERE SUBSTRING(TOUPPER(name) FROM 1 FOR 1) NOT IN ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.

SELECT id, name FROM drinks WHERE SUBSTRING(TOUPPER(name) FROM 1 FOR 1) NOT IN ('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T','U','V','W','X','Y','Z') ORDER BY name