BUG #1313: problems with array syntax parsing in SQL statements

Поиск
Список
Период
Сортировка
Искать
От
PostgreSQL Bugs List
Тема
BUG #1313: problems with array syntax parsing in SQL statements
Дата
Msg-id
20041111195530.9AB717388A2@www.postgresql.com
Список
Дерево обсуждения
BUG #1313: problems with array syntax parsing in SQL statements "PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>
Re: BUG #1313: problems with array syntax parsing in SQL Joe Conway <mail@joeconway.com>
The following bug has been logged online:

Bug reference:      1313
Logged by:          Pascal Pochet

Email address:      postgresql@p3-consulting.net

PostgreSQL version: 7.4.5

Operating system:   Mac OS X

Description:        problems with array syntax parsing  in SQL statements

Details: 

In INSERT statements the string '{}' is correctly parsed as an empty array 
when '{ }' is not, as if the space was signifiant, and generates a syntax 
error. 

Also
'{"A", "B"}' will be correctly parsed when 
'{"A", "B" }' (note the space before the closing brace ) will generate the 
following entry '{"A","B "} : the space(s) between the latest double quote 
and the closing brace is/are added to the latest item of the array.
В списке pgsql-bugs по дате отправления
От: Bruce Momjian
Дата:
От: Josh Berkus
Дата:
FAQ