On Mon, 16 Dec 2013 12:28:36 +0100, Dimitry Sibiryakov <s...@ibphoenix.com> wrote: > 16.12.2013 12:18, Alex Peshkoff wrote: >> On 12/16/13 15:14, Dimitry Sibiryakov wrote: >>> Why one is needed? You can tell whether it is fixed or optional >>> property by name, can't >>> you?.. >>> >> To make SQL operator human-readable. And must say I like this suggestion >> >> create user x password 'y' attributes (a = 'a', b = 'b'); >> alter user x set password 'yy' attributes (a = 'aa', b = 'bb'); > > But aren't fixed attributes also attributes? I don't really see where > is > non-readability in syntax like this: > > create user x attributes (password = 'y', a = 'a', b = 'b'); > alter user x set password = 'yy', a = 'aa', b = 'bb'; > > Syntax diagram is the same as for UPDATE statement.
A user needs to have a password, it does not need to have attribute (or maybe: extended properties is a better name). Mark ------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel