On 23 Jun 2010, at 12:53pm, Igor Tandetnik wrote: > Ian Hardingham <i...@omroth.com> wrote: >> I'm just getting around to this. Can I do: >> >> ALTER TABLE userTable ADD upperName = upper(name) TEXT >> >> Will this retroactively and for all future inserts work? > > This is not a valid syntax, so it won't work - neither retroactively, in the > present, nor in the future. It's not even clear to me what you are trying to > achieve here.
Some sort of stored function ? So he can store retrieve a pseudo-column from a TABLE and SQLite will perform a calculation for him. It might be possible to do it with a VIEW: CREATE VIEW funcViewUserTable AS SELECT *,upper(name) AS upperName FROM userTable Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
