So, Postmodern doesn't seem to have very minimal support for views (just `list-views' and `view-exists-p'), but I assume I can still work with them? Any tips on that?
On Wed, Nov 14, 2007 at 06:34:31PM -0600, Joe Corneli wrote:
So, Postmodern doesn't seem to have very minimal support for views (just `list-views' and `view-exists-p'), but I assume I can still work with them? Any tips on that?
I think you can treat them just like tables.
Zach
Hey Joe,
Views are indeed something that I didn't pay much attention to -- I'm not really in the habit of making much use of them myself. As Zach said, they can be treated as tables when selecting, but S-SQL does not have :create-view or :drop-view operators defined, so to make them convenient to work with you'd want to either add that, or do all your creating/dropping directly from the SQL prompt. (If you end up adding them, I'd be happy to apply your patch to the repository).
Cheers, Marijn
postmodern-devel@common-lisp.net