funny psql output

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: funny psql output
Date: 1999-10-19 04:13:31
Message-ID: 199910190413.AAA21492@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Does this look strange to anyone:

test=> create table kk1 (born date);
CREATE
test=> select * from kk1;
born
----
(0 rows)

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?

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-10-19 04:29:40 Re: [HACKERS] Another historical message from the early days of PostgreSQL development
Previous Message Tom Lane 1999-10-19 03:17:37 Re: [HACKERS] sort on huge table