e wonder--is there any downside or unwelcome side effects
> to having such a cast? And if not, why isn't it part of the default setup?
>
> Cheers,
> Ken
>
> On Sat, Feb 21, 2015 at 3:34 AM, sridhar bamandlapally <
> sridhar@gmail.com> wrote:
>
>> Hi
>
sts this possibility.
>
> "If DISTINCT is specified, all duplicate rows are removed from the result
> set..."
> http://www.postgresql.org/docs/9.0/static/sql-select.html#SQL-DISTINCT
>
> Cheers,
> Ken
>
> On Fri, Feb 20, 2015 at 6:30 PM, sridhar bamandlapally <
> sridhar...
>>>ERROR: column "my_array" is of type character varying[] but expression
is of type text
please try this below, may be this should help
CREATE CAST (text AS varchar) WITH INOUT AS IMPLICIT;
just for info:
actually this should be available in default
On Fri, Feb 20, 2015 at 9:48 AM, Ken Tanze
Hi
With minimal application code changes we are able to migrate database from
Oracle to PostgreSQL successfully (including performance issues) on
production
This we did on high read intensive database sized 900+GB
Thanks to PostgreSQL
Thanks
Sridhar BN
