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 ...  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Cedar Cox
Дата:
Сообщение: Re: please help
Следующее
От: Tomáš Nohejl
Дата:
Сообщение: create function