Please reply to the list also in the future, I'm going to sleep now. Anyway, it still works:
kleptog=# create temp table x (a text);
CREATE TABLE
kleptog=# insert into x values (nullif('',''));
INSERT 114760 1
kleptog=# insert into x values (nullif('1',''));
INSERT 114761 1
kleptog=# select a,a is null as isnull from x;
a | isnull
---+--------
| t
1 | f
(2 rows)
Please show us the error you got.
Have a nice day,
On Thu, Aug 25, 2005 at 02:57:29PM -0700, Matt A. wrote:
> hi. I am speaking of INSERT not SELECT
>
> --- Martijn van Oosterhout <kleptog@svana.org> wrote:
>
> > Very odd, what are you trying?
> >
> > kleptog=# select nullif('','') is null;
> > ?column?
> > ----------
> > t
> > (1 row)
> >
> > kleptog=# select nullif('1','') is null;
> > ?column?
> > ----------
> > f
> > (1 row)
> >
> > Works for me.
> >
> > Have a nice day,
> >
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
pgpyRFqMqlNzG.pgp
Description: PGP signature
