On 06/03/16 08:51, Mark Rotteveel wrote: >> I don't think that the SQL standard ever imposed an order on these? But >> > both MySQL and Postgresql seem to standardise on the DEFAULT last :( > The SQL standard specifies that the default clause follows the data type > definition. And this is what Firebird does. The syntax in the SQL > Standard is defined as:
Ta ... I knew there was a reason ... but I did my talks on inter database operability at the conferences 10 years ago :) But I doubt that MySQL and Postgresql will fix that now :( -- Lester Caine - G8HFL ----------------------------- Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
