Thomas Lockhart <[EMAIL PROTECTED]> writes: >> I can certainly think of uses for a local-effects flavor of SET. >> But I don't want that to be the only flavor.
> Right. And there was no suggestion that there be so; the original > proposal used "BEGIN/END blocks" to differentiate the usage. Right. But I don't like the notion of making SET's behavior vary depending on context. I think it's better both from a user-friendliness standpoint and from a compatibility standpoint to use different syntaxes to indicate the desired behavior. > Think about > SET SESSION... as a possible syntax to completely decouple the behaviors > if an explicit notation is desired. Well, if you accept the notion of distinguishing it by syntax, then we're down to arguing about which case should be associated with the existing syntax. And I think persistent has to win on compatibility grounds. (Doesn't the Perl DBI driver also do the automatic-begin thing? Breaking all Java apps and all Perl apps that issue SETs is rather a big compatibility problem IMHO...) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly