Re: open and closed paths ... - Mailing list pgsql-sql

From Hans-Jürgen Schönig
Subject Re: open and closed paths ...
Date
Msg-id 3AD16CB2.633AF77B@cybertec.at
Whole thread Raw
In response to Re: open and closed paths ...  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Re: open and closed paths ...
List 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 by date:

Previous
From: Cedar Cox
Date:
Subject: Re: please help
Next
From: Tomáš Nohejl
Date:
Subject: create function