Re: open and closed paths ...

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: open and closed paths ...
Date: 2001-04-09 08:02:58
Message-ID: 3AD16CB2.633AF77B@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message datactrl 2001-04-09 08:10:56 install pgSQL 7.1
Previous Message Cedar Cox 2001-04-08 23:57:05 Re: Need help with EXECUTE function