Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> writes:
> test=> insert into kk1 values ('1/1/1990');
> INSERT 18588 1
> test=> select * from kk1;
> born
> ----------
> 01-01-1990
> (1 row)
> Look how 'born' is right-shifted in the column. Any idea why?
I think libpq's print routine is deciding that the column is numeric.
(all digits and minus signs ... and IIRC it's not very picky about
where the minus signs are...)
Perhaps Peter will fix this during his massive rewrite.
regards, tom lane