Skip site navigation (1) Skip section navigation (2)

Re: [PORTS] Port Bug Report: Can not create table with a number as first character

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: Michael Kraus <magnum3171(at)aol(dot)com>
Cc: pgsql-ports(at)postgreSQL(dot)org
Subject: Re: [PORTS] Port Bug Report: Can not create table with a number as first character
Date: 1999-03-03 04:52:37
Message-ID: 36DCC015.82B8DB3D@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-ports
> Summary: Can not create table with a number as first character
>   PostgreSQL version : 6.4.2
> create table 622 (etc char(25));
> create table v-22 (etc char(10));

You must use the SQL92 conventions to accomplish this:

postgres=> create table "622" (etc char(25));
CREATE
postgres=> insert into "622" values ('hi there');
INSERT 144982 1
postgres=> select * from "622";
etc
-------------------------
hi there
(1 row)

Same with your hyphen example. Good luck.

                   - Tom

In response to

pgsql-ports by date

Next:From: Thomas G. LockhartDate: 1999-03-03 15:28:10
Subject: Re: [PORTS] Port Bug Report: Error with date_part when checking month
Previous:From: Billy G. AllieDate: 1999-03-03 03:51:06
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group