Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-13 Thread hubert depesz lubaczewski
On 7/11/06, Paul Tilles <[EMAIL PROTECTED]> wrote: Yes.  That works.  I think that the parser should work properly either way.it works properly. just the proper way of functioning is not the one you would like to have.you can simply add this operator: CREATE FUNCTION not_equals_minus(int8, int8) RE

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative

2006-07-12 Thread Oisin Glynn
Scott Marlowe wrote: On Wed, 2006-07-12 at 05:55, Clodoaldo Pinto wrote: 2006/7/11, Oisin Glynn <[EMAIL PROTECTED]>: 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 doe

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-12 Thread Bruno Wolff III
On Wed, Jul 12, 2006 at 07:55:49 -0300, Clodoaldo Pinto <[EMAIL PROTECTED]> wrote: > > I have already counted 6 very similar answers. Is there some problem > with the list software that prevents people from noticing it has > already been answered? In my case, my mail server had been heavily loa

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative

2006-07-12 Thread Scott Marlowe
On Wed, 2006-07-12 at 05:55, Clodoaldo Pinto wrote: > 2006/7/11, Oisin Glynn <[EMAIL PROTECTED]>: > > 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

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-12 Thread David Fetter
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

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-12 Thread Clodoaldo Pinto
2006/7/11, Oisin Glynn <[EMAIL PROTECTED]>: 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

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-11 Thread Bruno Wolff III
On Tue, Jul 11, 2006 at 13:11:16 -0400, Paul Tilles <[EMAIL PROTECTED]> 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 ma

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative

2006-07-11 Thread Bruce Momjian
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

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-11 Thread Oisin Glynn
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 ca

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-11 Thread Paul Tilles
Yes. That works. I think that the parser should work properly either way. 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 !=- i

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-11 Thread Tim Hart
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Tilles Sent: Tuesday, July 11, 2006 12:11 PM To: pgsql-general@postgresql.org Subject: [GENERAL] doesn't recognize "!=-" (not equal to a negative value) Version postgres 7.4.7: Following sql UPDATE tablename SET valu

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-11 Thread Eric B. Ridge
On Jul 11, 2006, at 1:11 PM, Paul Tilles wrote: 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. I'm pretty sure the SQL-standard spelling of "not equals" is "<>". Postgres support

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative

2006-07-11 Thread Scott Marlowe
On Tue, 2006-07-11 at 12:11, 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

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-11 Thread Tom Lane
Paul Tilles <[EMAIL PROTECTED]> writes: > UPDATE tablename SET value = 0.0 where value!=-9.4; > 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. This is not a bug, this is a feature.

[GENERAL] doesn't recognize "!=-" (not equal to a negative value)

2006-07-11 Thread Paul Tilles
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. Seems that po