Re: Empty to NULL conversion - Ruby - Postgres ?

Steve/Jeff,

Thanks for your replies. I am using the latest "pg" module but I don't
know if there is any way to handle this without SQL. I am manually
taking care of it using SQL functions to convert empty strings to
NULL. It would be nice if there is a setting that could take care of
this issue.

PS: This issue is similar to COPY where by default "" is considered
empty and not NULL and so you can't load this data into a NUMERIC data
type defined as NULL. COPY has a WITH NULL AS syntax which addresses
this issue.

On Feb 5, 2008 5:47 PM, Jeff Davis <pgsql@j-davis.com> wrote:
> On Fri, 2008-02-01 at 20:33 -0500, Venks wrote:
> > Hi,
> >
> > I am trying to copy some data from MySQL to Postgres using Ruby. This
> > is NOT a MySQL to PostgreSQL conversion project. I need to read the
> > data from a MySQL database and load it into PostgreSQL database.
> >
> > How do I handle "nil" in ruby and convert them into NULL so that I can
> > insert NULL into INT columns instead of empty values? In short I am
> > getting the following popular error:
> >
>
> Can you install the latest module from the ruby-pg project (or just "gem
> install pg").
>
> If you have this problem still, send an email to the ruby-pg-general
> mailing list (or post in the forum, or email me directly).
>
> Regards,
>        Jeff Davis
>
>