On Fri, 20 Sep 2002, Yury Bokhoncovich wrote:
> Maybe I missed something but what are reasons to change behaviour in 7.2
> in comparison with 7.1?
> I mean that early PG just truncated the rest (tail) of extra long string
> (i.e. where len(string)>char(this attr) but insert the head. Now inserting
> fails. Is it tunable somewhere in GUC so I could revert to old behaviour?
Not currently. This was a push to become more complient with sql's
desired handling for strings like that.
> And yet, what is the Right Way to deal with timestamp?
> Now I'm using Thomas's recipe \"timestamp\" but it loooks wierd and bad.
For most of the uses of timestamp(), you probably should now be using
either a timestamp literal (timestamp '...') or a cast (cast(... as
timestamp). The reason this changed was again an sql compatibility issue,
timestamp(n) in sql terms is a type with a particular precision.