Re:
От | Tom Lane |
---|---|
Тема | Re: |
Дата | |
Msg-id | 28332.1040610393@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | ... ("Billy G. Allie" <Bill.Allie@mug.org>) |
Список | pgsql-general |
"Billy G. Allie" <Bill.Allie@mug.org> writes: > I have a question about the behavior of the array input routine. How should > the input string, '{abc"def,defghi",jklmnop}' be parsed? I would think it > should produce '{"abc\"def","defghi\"","jklmnop"}', but it currently (as of > 7.3) produces '{"abcdef,defghi","jklmnop"}'. As did 7.2. Previous releases (at least back to 7.0, the oldest I have handy to test) did this: regression=# select '{abc"def,defghi",jklmnop}'::text[]; ?column? -------------------------- {"def,defghi","jklmnop"} (1 row) which is certainly pretty bogus, but it established the precedent that a double-quoted string could be a substring of an array element, and more specifically that double-quote didn't stop being special just because it wasn't the first character of the element string. > Which should be the correct behavior? I can't see any strong argument in favor of your proposed change. I can tell you that we will get beat up about it if we change anything in this line --- so you'd better muster a pretty strong argument. regards, tom lane
В списке pgsql-general по дате отправления: