Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@wjessop

wjessop/gist:511197

Created August 6, 2010 11:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wjessop/511197 to your computer and use it in GitHub Desktop.
Save wjessop/511197 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment