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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html