Re: open and closed paths ...
От | Hans-Jürgen Schönig |
---|---|
Тема | Re: open and closed paths ... |
Дата | |
Msg-id | 3AD16CB2.633AF77B@cybertec.at обсуждение исходный текст |
Ответ на | Re: open and closed paths ... (Peter Eisentraut <peter_e@gmx.net>) |
Ответы |
Re: Re: open and closed paths ...
|
Список | pgsql-sql |
The only problem left is the correct syntax of the command when using []. I've tried some versions but it did not work. Maybe Tom can include an example into the docs. Hans shop=# INSERT INTO temppath(fieldname) VALUES '((1,3), (4,12))'; ERROR: parser: parse error at or near "'" shop=# INSERT INTO temppath(fieldname) VALUES ((1,3), (4,12)); ERROR: parser: parse error at or near "," shop=# INSERT INTO temppath(fieldname) VALUES ('(1,3), (4,12)'); INSERT 51947 1 shop=# INSERT INTO temppath(fieldname) VALUES ['(1,3), (4,12)']; ERROR: parser: parse error at or near "[" shop=# INSERT INTO temppath(fieldname) VALUES '[(1,3), (4,12)]'; ERROR: parser: parse error at or near "'" shop=# INSERT INTO temppath(fieldname) VALUES '[(1,3), (4,12)]'::path; ERROR: parser: parse error at or near "'" shop=# INSERT INTO temppath(fieldname) VALUES ['(1,3), (4,12)']::path; ERROR: parser: parse error at or near "[" shop=# SELECT isopen(fieldname) FROM temppath;isopen --------f (1 row)
В списке pgsql-sql по дате отправления: