[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
>
--
benh~
More information about the Pdx-pm-list
mailing list