Received: from smtpout.mac.com (smtpout.mac.com [204.179.120.89]) by postgresql.org (Postfix) with ESMTP id 6848A47590B for ; Sun, 14 Jul 2002 01:09:09 -0400 (EDT) Received: from smtp-relay01.mac.com (smtp-relay01-en1 [10.13.10.224]) by smtpout.mac.com (8.12.1/8.10.2/1.0) with ESMTP id g6E595TQ004313 for ; Sat, 13 Jul 2002 22:09:05 -0700 (PDT) Received: from asmtp01.mac.com (asmtp01-qfe3 [10.13.10.65]) by smtp-relay01.mac.com (8.12.1/8.12.1/1.0) with ESMTP id g6E590Wf021799 for ; Sat, 13 Jul 2002 22:09:00 -0700 (PDT) Received: from localhost ([24.68.198.74]) by asmtp01.mac.com (Netscape Messaging Server 4.15) with ESMTP id GZ83MZ00.L1P for ; Sat, 13 Jul 2002 22:08:59 -0700 Date: Sat, 13 Jul 2002 23:09:15 -0600 Mime-Version: 1.0 (Apple Message framework v482) Content-Type: text/plain; charset=US-ASCII; format=flowed Subject: line datatype From: Tim Hart To: pgsql-sql@postgresql.org Content-Transfer-Encoding: 7bit Message-Id: X-Mailer: Apple Mail (2.482) X-Archive-Number: 200207/212 X-Sequence-Number: 8590 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?