Re: issue with an assembled date field

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Chris Bowlby <excalibur(at)accesswave(dot)ca> writes:
>  I am converting an encoded field (lot_id) into a date field, the 5
> character of every lot_id is always the year and as such I need to
> extract the year using the following function:
>  substring(ilch.lot_id::text, 5, 1)

Well, I'd say that the failure proves that some of your data does
*not* have the year in the fifth character.

> ERROR:  invalid input syntax for type date: "01/01/0W"

Time for some data sanitizing?

			regards, tom lane