Re: what is the difference between default 0 vs default '0'

From: Lee Harr <missive(at)frontiernet(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: what is the difference between default 0 vs default '0'
Date: 2002-06-26 02:35:28
Message-ID: afb99f$1lgf$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In article <000c01c21cab$c2f35ef0$6901a8c0(at)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-06-26 06:46:32 Re: what is the difference between default 0 vs default '0'
Previous Message Beth Gatewood 2002-06-26 00:52:34 what is the difference between default 0 vs default '0'