Horton

Re: Change in casting behavior?

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Thomas Swan <tswan-lst@ics.olemiss.edu>
Cc: Postgresql Hackers <pgsql-hackers@postgresql.org>
Date: 2002-02-16T01:35:49Z
Lists: pgsql-hackers 
Thomas Swan writes:

> select (random( )*10)::varchar(4)
> worked in 7.1.3
>
> fails in 7.2
>
> ERROR:  value too long for type character varying(4)

Say what you really mean:

select substring(random()*10 for 4);

-- 
Peter Eisentraut   peter_e@gmx.net