From: | Tim Hart <tjhart(at)mac(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Fwd: line datatype |
Date: | 2002-07-15 03:32:35 |
Message-ID: | 8109AB25-97A3-11D6-8730-000393460410@mac.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Probably the most succinct explanation would be to copy & paste from the
terminal...
tjhart=> create table a_line( foo line );
CREATE
tjhart=> insert into a_line ( foo ) values( '(0,0), (1,1)' );
ERROR: line not yet implemented
tjhart=> select version();
version
---------------------------------------------------------------------
PostgreSQL 7.2.1 on powerpc-apple-darwin5.3, compiled by GCC 2.95.2
(1 row)
The documentation (datatype-geometric.html) indicates both a 'line' type
and an 'lseg' type in the summary table at the top of the page. The same
code above using the type 'lseg' in place of 'line' works just fine.
Why can I create a table with a column of type 'line' if I can't insert
into it?
From | Date | Subject | |
---|---|---|---|
Next Message | Luis Alberto Amigo Navarro | 2002-07-15 07:45:36 | Re: [HACKERS] please help on query |
Previous Message | Tom Lane | 2002-07-15 03:27:41 | Re: Sorry.. |