Re: Hex literals
От | Peter Eisentraut |
---|---|
Тема | Re: Hex literals |
Дата | |
Msg-id | Pine.LNX.4.44.0207301919270.1928-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Hex literals (Thomas Lockhart <lockhart@fourpalms.org>) |
Список | pgsql-hackers |
Thomas Lockhart writes: > 31) Specifications for Feature F511, "BIT data type": > a) Subclause 5.3, "<literal>": > i) Without Feature F511, "BIT data type", a <general literal> > shall not be a <bit string literal> or a <hex string > literal>. > > This seems to be a hard linkage of hex strings with the BIT type. You'll also find in 5.3 Conformance Rule 9) 9) Without Feature T041, "Basic LOB data type support", conforming Core SQL language shall not containany <binary string literal>. which is an equally solid linkage. I might also add that the rules concerning the absence of a feature do not determine what happens in presence of a feature. ;-) Let's think: We could send a formal interpretation request to the standards committee. (They might argue that there is no ambiguity, because the target type is always known.) Or we could check what other database systems do. In any case, I'd rather create a readable syntax for blob'ish types (which the current bytea input format does not qualify for) rather than mapping hexadecimal input to bit types, which is idiosyncratic. -- Peter Eisentraut peter_e@gmx.net
В списке pgsql-hackers по дате отправления: