open and closed paths ...

From: Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
To: pgsql-sql(at)postgresql(dot)org
Subject: open and closed paths ...
Date: 2001-04-08 13:59:25
Message-ID: 3AD06EBD.8EE8C6D7@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am using PostgreSQL 7.0.3. I have tried the isopen() function but it
doesn't seem to work (or it is not fully implemented yet).
In my opinion the third record is a closed path but the isopen()
functions return f.
Have I done something wrong, have I got something wrong or is it a bug?

Hans

shop=# SELECT * FROM temppath;
fieldname
----------------------
((1,3),(4,12))
((3,1),(2,8),(10,4))
((3,1),(2,8),(3,1))
((1,1),(2,2),(3,3))
(4 rows)

shop=# INSERT INTO temppath(fieldname) VALUES ('(1,1), (2,3)');
INSERT 51857 1
shop=# SELECT isopen(fieldname) FROM temppath;
isopen
--------
f
f
f
f
f
(5 rows)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-04-08 21:15:57 Re: open and closed paths ...
Previous Message Peter Eisentraut 2001-04-08 10:05:42 Re: Casting numeric to text