Re: Postgres SQL Syntax

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/01/07 19:02, Jim C. wrote:
> I've a postgres statement that reads:
>
> CREATE TABLE "channel" (

Do you *need* object names to be case-sensitive?

If not, it's a bad habit to get in to.  Makes more work for you and
the developers.

>     "chanid" int NOT NULL default '0',

Besides what Tom says, '0' is a string, not an integer.  PG takes
it, but it's a bad habit.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFwrRBS9HxQb37XmcRAsj4AJ42ni3Oz4DUbJP5KfU7p390Tr83LACfb2Cu
nvS7GBghjPQK4sG1Da3ONZ8=
=cCnZ
-----END PGP SIGNATURE-----