akestion wrote:

> Can you tell me how to declare a check constraint such as :
>
> PRIMARY KEY check(typeAvion like '[A-Z]%'),

If all else fails, you can use SUBSTRING in a little awkward way:

check (substring(typeAvion from 1 for 1) between 'A' and 'Z')

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net