Hello
I know that exists a script file in postgres (I think) that have all of
these operators. But what is the name of the file ?
Is it in the package of postgresql by defualt ? If not, can someone send
me that file ?
Thanks
Luis Sousa
---(end of broadcast)---
Hello,
we updated one of our systems from postgresql 8.2 to 8.3 and now some
queries are generating errors that no operator matches the given name
and argument type. That is not surprising as in v8.3 the automatic
casting was removed what troubles me is that sometimes it still casts
select '
Julius Tuskenis writes:
> select '1' = 1 results in true
This is a undecorated literal, which PostgreSQL will cast as integer
when it discovers that's what makes sense.
> while select sum(msg_price) from messages where msg_itemid = 0 results in
> error:
> ERROR: operator does not exist: charac
Thank you for your informative answer.
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Julius Tuskenis writes:
> we updated one of our systems from postgresql 8.2 to 8.3 and now some
> queries are generating errors that no operator matches the given name
> and argument type. That is not surprising as in v8.3 the automatic
> casting was removed what troubles me is that sometimes i