On May 20, 2008, at 3:40 PM, Jeff Hamilton wrote:
> This works in the simple case that I described, but in practice I'd
> like to use the pattern on more complex tables that have existing
> uniqueness constraints. Using REPLACE INTO will get in the way of
> those constraints.
>
OK. How about:
INSERT INTO foo(bar) VALUES(coalesce(?,'default-value'));
D. Richard Hipp
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
