Search Postgresql Archives

Re: type casting in 8.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Feb 11, 3:15 am, "${spencer}" <spenc...@xxxxxxxxx> wrote:
> I just literally ran my first search of the day and got the same
> error.
>
> i changed my query so that the integer was cast into text and then it
> worked fine.
>
> thefro...@xxxxxxxxx wrote:
> > All,
>
> > I'm getting the following (new) (php?) error on a database recently
> > moved from 8.2.6 to 8.3. I know there's been changes with casts in 8.3
> > and I intend to learn how to fix them but I don't know how to
> > interpret the error:
>
> > ERROR: operator does not exist: character <> integer LINE 1: ...
> > 303841-9' and amount > 0 and quant > 0 and reg_id != 99) gro... ^
> > HINT: No operator matches the given name and argument type(s). You
> > might need to add explicit type casts.
>
> > I think that
>
> > operator does not exist: character <> integer
>
> > is the key here. Does it mean the query is trying to interpret a text
> > string as an integer? The string ...303841-9 is an ISBN number and is
> > char(16) in the table.
>
> > Thanks for any pointers or links to a tutorial.
>
> > tf


Ya know, I found and fixed my problem today at work. I just explicitly
cast everything in the query and as I worked my way through it I
watched how the error message changed. At the very end I came up to
something like "...and store != $store". I changed it to "...and
store != '$store'" and, bingo the query worked again. Then I backed
out all the :: casting I had done and everything still worked. 'magine
that.

tf

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux