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 ... Hans-Jürgen Schönig <hs@cybertec.at>
Re: Re: open and closed paths ... Peter Eisentraut <peter_e@gmx.net>
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 по дате отправления
От: Cedar Cox
Дата:
Сообщение: Re: please help
От: Tomáš Nohejl
Дата:
Сообщение: create function
FAQ