[Pdx-pm] DBI middle ground

benh ben.hengst at gmail.com
Mon Jan 29 10:23:00 PST 2007

I know that mysql (5+?) has a IFNULL() so you can specify a
replacement value for NULLs

so an example would be something like:

select IFNULL(possible_null,"this value is null") from table;

On 1/29/07, Jeff Zucker <jeff at vpservices.com> wrote:
> Michael Rasmussen wrote:
> > so db functions, or changes to the exisiting db functions to apply rules I need
> > are not available.  This is part of the reason I'm making a local copy of the data
> > of interest.
> >
> What about built-in functions like COALESCE() which would let the db
> deal with nulls.  You don't need any special privs to use those.
> --
> Jeff
> _______________________________________________
> Pdx-pm-list mailing list
> Pdx-pm-list at pm.org
> http://mail.pm.org/mailman/listinfo/pdx-pm-list


More information about the Pdx-pm-list mailing list