Re: what is the difference between default 0 vs default '0' - Mailing list pgsql-sql

In article <000c01c21cab$c2f35ef0$6901a8c0@bethvizx>, "Beth Gatewood" wrote:
> all-
> Could somebody tell me why I would use default 0 vs default '0' in the
> following....
> CREATE TABLE foo (col1 INTEGER default 0) <-- or default '0'
> 

0 is an integer
'0' is a string

default '0' might work (through type coercion)
but I think default 0 is more clear.