Re: Postgres SQL Syntax - Mailing list pgsql-general

From Ron Johnson
Subject Re: Postgres SQL Syntax
Date
Msg-id 45C2B441.6070604@cox.net
Whole thread Raw
In response to Postgres SQL Syntax  ("Jim C." <jlistnews@gmail.com>)
Responses Re: Postgres SQL Syntax  ("Jim C." <jlistnews@gmail.com>)
List pgsql-general
-----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-----

pgsql-general by date:

Previous
From: RPK
Date:
Subject: PostgreSQL/FireBird
Next
From: Ron Johnson
Date:
Subject: Re: PostgreSQL/FireBird