From: Henning T. <has...@he...> - 2008-07-03 10:35:11
|
When using HaskellDB to call HSQL/Oracle, it generates an SQL query like SELECT TITLE FROM COURSES as T1 Our Oracle DB doesn't like the 'as', it says *** Exception: user error (ORA-00933: SQL command not properly ended ) Without the 'as' the query is processed. I looked into Database.HaskellDB.Sql.Print, especially ppAs, but the pretty printing does not depend on the Database back-end. How can I achieve that the 'as' is not generated for Oracle or is there an SQL syntax that is understood by all databases? |