![](https://secure.gravatar.com/avatar/f6a35c85d26694e26bb92ea4d4262c77.jpg?s=120&d=mm&r=g)
30 Aug
2009
30 Aug
'09
6:03 p.m.
* (s-sql:sql-compile '(:select (:currval players_id_seq))) "(SELECT currval(players_id_seq))"
* (s-sql:sql-compile '(:select (:currval players_id_seq))) "(SELECT currval(E'players_id_seq'))"
It seems that the default function expansion doesn't escape object names.
The Postgresql currval/nextval functions take strings. Passing a symbol, in S-SQL means passing an identifier. If you are generating s-sql expressions, have a symbol where you need a string, you can just call to-sql-name on it. Doing it that way should also make calling setval easier. Best, Marijn