On Tue, Jul 11, 2006 at 04:26:41PM -0400, Paul Tilles wrote:
> Yes. That works. I think that the parser should work properly either way.
You're mistaken. PostgreSQL by design makes it possible for you to
define a custom operator like !=- and use it.
>
> Paul
>
> Bruce Momjian wrote:
> >Paul Tilles wrote:
> >
> >>Version postgres 7.4.7:
> >>
> >>Following sql
> >>
> >>UPDATE tablename SET value = 0.0 where value!=-9.4;
> >>
> >>results in the error message
> >>
> >>ERROR: operator does not exist: smallint !=- integer
> >>HINT: No operator matches the given name and argument type(s). You may
> >>need to add explicit type casts.
> >>
> >
> >Have you tried?
> >
> >value != -9.4
> >
> >---------------------------------------------------------------------------
> >
> >
> >>Seems that postgres has a problem parsing a "not equal negative value".
> >>
> >>Anybody know if this is fixed in later versions?
> >>
> >>Paul Tilles
> >>
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 4: Have you searched our list archives?
> >>
> >> http://archives.postgresql.org
> >>
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666
Skype: davidfetter
Remember to vote!