From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tim Hart <tjhart(at)mac(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: line datatype |
Date: | 2002-07-16 03:33:48 |
Message-ID: | 200207160333.g6G3Xnc22777@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
OK, I have added comments to \dT and SGML docs to mention that 'line' is
not implemented. This should help future folks.
It would be nice to get the line type working 100%. Thomas says the
problem is input/output format. I don't completely understand.
---------------------------------------------------------------------------
Tim Hart wrote:
> 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?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-07-16 03:46:30 | Re: DROP COLUMN |
Previous Message | Thomas Lockhart | 2002-07-16 03:20:25 | Re: bit type external representation |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2002-07-16 06:10:29 | Re: [SQL] line datatype |
Previous Message | Stephan Szabo | 2002-07-16 00:42:51 | Re: Indexing UNIONs |