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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-ports by date

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