macaddr data type issue
От | Gayland Gump |
---|---|
Тема | macaddr data type issue |
Дата | |
Msg-id | Pine.BSO.4.33.0108210841480.4215-100000@shell.pacifier.com обсуждение исходный текст |
Список | pgsql-general |
Hi, I am looking for some confirmation and perhaps some explanation of and for the following observation. If I use "000000-000000" as input to a macaddr data type element in my database no value appears to be stored. I was intending to use this value as a "missing data" marker in my application. I've looked for documentation high and low but haven't been able to find anything regarding this behavior. I did stumble upon some source code, which I believe is relevant, which suggests that the code's author was planning for a "missing value's" value. Unfortunately, the macaddr data type output function does not seem to produce the "00:00:00:00:00:00" string that I would expect. It seems to me that if I were to input and the database would accept "000000-000000" as indicative of missing values that the database should output such a value when it is encountered in a dataset. At very least, it would seem that some additional documentation might be warranted. I suspect I am missing something here. Can anyone offer confirmation of this behavior and an explanation for, what seems to me to be, this counter-intuitive behavior? Thanks for your time and effort on my behalf. Gayland
В списке pgsql-general по дате отправления: