Re: [SQL] line datatype

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [SQL] line datatype
Дата
Msg-id 200207160333.g6G3Xnc22777@candle.pha.pa.us
обсуждение исходный текст
Список pgsql-hackers
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@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: bit type external representation
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: DROP COLUMN