On 05/28/2010 02:04 PM, erobles wrote:
On 05/28/2010 01:51 PM, Adrian Klaver wrote:
On 05/28/2010 11:45 AM, erobles wrote:
On 05/28/2010 01:26 PM, Adrian Klaver wrote:
On 05/28/2010 11:20 AM, erobles wrote:
hi!
only for ask, there is a way to deactivate type validation, so i
can do
select rtrim(number_field) from table ; with no error and the
message:
"You might need to explicit type casts"
this is postgres 8.3.1.
What are you trying to do? I am trying to think what rtrim does on a
number.
you are right, i'm trying to make a rtrim to a number.
the reason of my question is we have a lot of apps with similar
querys ,
when we have postgres7.2 this kind of querys just simply execute very
well, so.. when change to postgres 8.3 this querys fail beacuse they
needit an explicit cast.
one solution is change the querys of apps and recompile, but time is
short and the deadline is near.
other solution is create a function to each explicit cast, but we dont
have the time to research if there are more mismatch querys.
so the easy way is deactivate the validation type ...
so another
For short term solution see here:
http://petereisentraut.blogspot.com/2008/03/readding-implicit-casts-in-postgresql.html
thanks, downloading and testing.....
it did'nt work :-( , because the script is for pg 8.2 and i have pg
7.2 and the table pg_cast doesn't exist. whatever is a good idea but i
need to know the table or tables on postgres 7.2. such as pg_cast
on postgres 8.3, to modify the script.
How can i see the 'private' tables of postgres 7.2, i tried with \d on
template1 , if a made a select on pg_types i have a result, but i don't
know which is the name of the others tables such a
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
