Hi Sabra, WITH isn't a regular operator -- it has custom syntax, and as such would require a custom s-sql operator. See s-sql/s-sql.lisp, it shouldn't be too hard, looking at the :function operator, to build a def-sql-op form for :with. If you get something working, I'd be happy to add it to the distribution. Best, Marijn On Thu, Oct 1, 2009 at 6:21 AM, Sabra Crolleton <sabra.crolleton@gmail.com> wrote:

I can't seem to get the syntax right using s-sql. I can write a straight sql statement, but it looks ugly in the middle of a lisp program.

Sample sql statement from the postgresql docs is:

WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS ( SELECT g.id, g.link, g.data, 1, ARRAY[g.id], false FROM graph g

UNION ALL SELECT g.id, g.link, g.data, sg.depth + 1, path || g.id, g.id = ANY(path) FROM graph g, search_graph sg

WHERE g.id = sg.link AND NOT cycle ) SELECT * FROM search_graph;

http://www.postgresql.org/docs/8.4/static/queries-with.html

Sabra

_______________________________________________ postmodern-devel mailing list postmodern-devel@common-lisp.net http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel