gistfile1.txt

psql (8.4.3)
Type "help" for help.

postgres=# create database win;
CREATE DATABASE
postgres=# \c win
psql (8.4.3)
You are now connected to database "win".
win=# create table great(excellent varchar(10));
CREATE TABLE
win=# insert into great(excellent) values ('postgres postgres postgres');
ERROR:  value too long for type character varying(10)
win=# select * from great;
 excellent 
-----------
(0 rows)
win=# drop table great;
DROP TABLE
win=# create table great(excellent date);
CREATE TABLE
win=# insert into great(excellent) values ('2039-100-100');
ERROR:  invalid input syntax for type date: "2039-100-100"
LINE 1: insert into great(excellent) values ('2039-100-100');
                                             ^
win=# insert into great(excellent) values ('2039-10-10');
INSERT 0 1