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 по дате отправления: