Re:

Just a short note on developing a coding "style".

While "order" is a reserved word in PostgreSQL, that doesn't mean that you
can't use the word for a table name, or, more precisely, part of a table name.

As an example, consider the following:

     CREATE TABLE order_tbl ...

The example embeds the word "order" into the the actual name of the table
"order_tbl".  This accomplishes a couple of things.  First, your table name is
intuitive - it's a table that contains orders.  Second, somewhere down the road
someone, maybe you, may be attempting to modify your code - since you've used
an intuitive "style" it will be easier to read and understand later.

I ran into a similar problem with column name in a table I named
"employee_tbl".  As it happens, "position" is a PostgreSQL reserved word, too.
I finally chose "job_description" as the column name.

Tamsin wrote:

> i would guess that order is a reserved word, as its used in queries like
> select * from customers order by customerid
> so its probably best not to use it as a tablename.
> HTH
> tamsin
>
> > -----Original Message-----
> > From: pgsql-novice-owner@postgresql.org
> > [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of
> > juerg.rietmann@pup.ch
> > Sent: 14 December 2000 15:30
> > To: pgsql-novice@postgresql.org
> > Subject: [NOVICE]
> >
> >
> > I have a question regarding a strange behaviour.
> >
> > I use postgreSQL 7.0.3 on SuSE Linux, Coldfusion 4.5.2 SP2 and the pgAdmin
> > 7.0.4. For development I use Ultradev 4.0.
> >
> > I created a database with
> >
> > createdb customer with a table order.
> >
> > The query select * from order dosn't work. Doing select * from "order" is
> > ok. When i do a query on as system table the quotes are not needed. Since
> > Ultradev builds queries without the quotes, I can't use the queries with
> > the quotes.
> >
> > Why do I need the quotes on my new defined table ? Is Encoding the point ?
> >
> > Thanks in advance ... jr
> >
> > ============================================
> > PFISTER + PARTNER, SYSTEM - ENGINEERING AG
> > Juerg Rietmann
> > Grundstrasse 22a
> > 6343 Rotkreuz
> > Switzerland
> >
> > phone: +4141 790 4040
> > fax: +4141 790 2545
> > mobile: +4179 211 0315
> > ============================================
> >
> >

--
John Burski
Chief IT Cook and Bottlewasher
911 Emergency Products, St. Cloud, MN
(320) 656 0076

++++++++++++++++++++++++++++++++++
+ How's your cheese holding out? +
++++++++++++++++++++++++++++++++++