Re: Postgres SQL Syntax

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres SQL Syntax
Date: 2007-02-02 03:47:13
Message-ID: 45C2B441.6070604@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2007-02-02 03:48:22 Re: PostgreSQL/FireBird
Previous Message Jim Nasby 2007-02-02 03:46:48 Re: SQL to get a table columns comments?