Search Postgresql Archives

Re: Postgres SQL Syntax

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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-----


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux