Re: typecaste object to array - Mailing list pgsql-general

From John R Pierce
Subject Re: typecaste object to array
Date
Msg-id 4B839CB3.90602@hogranch.com
Whole thread Raw
In response to typecaste object to array  (beulah prasanthi <itsbeulah@gmail.com>)
Responses Re: typecaste object to array  (Lew <noone@lwsc.ehost-services.com>)
List pgsql-general
beulah prasanthi wrote:
> i am doing j2ee project .I am getting list from the user i want to
> insert that list into array in postgres DB
> by doing this i cannot caste an instance object pgemail to type Type
> ARRAY
> Can we caste the object to array .please tell me

normally, you would want to store a list as rows in a table, not as a
SQL array.  as rows, you can use various SQL operations on the data, as
an array, it becomes a single field of a single row of a table, and is
much harder to do anything useful with the data.

as far as java typecasting, sorry, I can't help you there.


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Sorting performance vs. MySQL
Next
From: adam_pgsql
Date:
Subject: "make check" failed on 8.4.2 install