Re: Insertion of geometric type column with column[0], column[1] and etc.

On Mon, Oct 4, 2010 at 10:50 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Marcelo Zabani <mzabani(at)gmail(dot)com> writes:
>> While I have emphasized the POINT data type, it would be desirable that all
>> types in pgsql could be accessed/updated/inserted with the array-analogy (or
>> other analogy), so that we could easily map ANYTHING with ORM software these
>> days.
>
> Surely it would be better to get an ORM that can actually deal with the
> data types you wish to use.

*scratches head*

Yeah, but isn't the current behavior awfully flaky? ISTM that if you
insert into a subscripted column, you should either get an error, or
your data should end up in the table somewhere. Sending it merrily
off into the void is ... well, words fail me.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company