On Jan 25, 2008 8:39 PM, Barry Hart <[EMAIL PROTECTED]> wrote: > > > >SA to be (i.e. would View act read-only, etc.. though I guess VIEWs > >aren't necessarily purely read-only in some cases ?). > > Right. For example, I think SQL Server views are updateable to some extent > (depending on whether there's a table primary key in the column list, > whether there are joins, etc.) The rules for this are almost certainly > DB-specific, too.
<RANT ON> Well, since the disciples of SQL keep telling me how much clearer it is than other database languages... The Merriam-Webster defines view as: 1: extent or range of vision : sight <tried to keep the ship in view> <sat high in the bleachers to get a good view> 2: the act of seeing or examining : inspection; also : survey <a view of English literature> 3 a: a mode or manner of looking at or regarding something b: an opinion or judgment colored by the feeling or bias of its holder <in my view the plan will fail> 4: scene prospect <the lovely view from the balcony> 5: the foreseeable future <no hope in view> 6: a pictorial representation Touch, change, and update have very different definitions. So, for clarity, view should mean... view, regardless of what mangling of English various implementations of SQL try to perform. Look but don't touch. Read-only. <RANT OFF> -- Ubuntu Linux DC LoCo Washington, DC http://dc.ubuntu-us.org/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
