Neil Conway <[EMAIL PROTECTED]> writes: > Chris KL recently pointed out to me that we currently don't raise an > error when attempting to cast a zero-length string to a float: > Whereas int and numeric reject zero-length strings:
> So, should we fix oid and float? Yes, surely, unless someone wants to argue for reverting that change to pg_atoi. I can't see a reason for having them act inconsistently. While we are at it we should make sure these functions are all on the same page about allowing leading/trailing whitespace. I seem to recall that the spec says somewhere that both should be allowed ... but right now I do not think we allow trailing whitespace. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend