Hello Yuri,
> (sql-compile '(:cast (:as value :BIGINT)))
Aha -- I hadn't used CAST before, the fact that :as works here is kind
of incidental. CAST does exactly the same as the '::' operator, though
-- see the :type operator in S-SQL. Just removing 'cast' from the list
of reserved words is not a good idea, since then you can't have rows
named 'cast' in your tables anymore. I could add an operator like
this...
(def-sql-op :cast (value type)
`("CAST(" ,@(sql-expand value) " AS " ,(to-type-name type) ")"))
... but maybe it makes more sense not to support both syntaxes and
just use :type instead?
Cheers,
Marijn
_______________________________________________
postmodern-devel mailing list
[email protected]
http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel
