Thread

1. RE: very odd behavior

   Creager, Robert S <creagrs@louisville.stortek.com> — 2001-05-10T18:26:53Z

   desc is a keyword - ORDER BY DESC-ending
   
   Robert Creager
   StorageTek
   INFORMATION made POWERFUL
   
   > -----Original Message-----
   > From: newsreader@mediaone.net [mailto:newsreader@mediaone.net]
   > 
   > I have 7.1
   > 
   > Can someone take a look the following
   > and tell me why I'm getting errors?
   > I'm completely baffled!
   > ----------------------------
   > 
   > what=> create table bla(desc text,def text,data text);
   > ERROR:  parser: parse error at or near "desc"
   > what=> create table bla("desc" text,def text,data text);
   > CREATE
   > what=>
   
   

2. Re: very odd behavior

   newsreader@mediaone.net — 2001-05-10T18:50:55Z

   Thanks everyone for very quick reply.
   
   The reason I found odd was I had
   created another able with the same
   field name and don't recall having
   problems at the time with 7.0.3.
   Or did I get the same problem
   but I just forgot?  I dumped
   and reloaded 7.0.3 table to 7.1
   without problem though.
   
   On Thu, May 10, 2001 at 12:26:53PM -0600, Creager, Robert S wrote:
   > 
   > desc is a keyword - ORDER BY DESC-ending
   > 
   > Robert Creager
   > StorageTek
   > INFORMATION made POWERFUL
   > 
   > > -----Original Message-----
   > > From: newsreader@mediaone.net [mailto:newsreader@mediaone.net]
   > > 
   > > I have 7.1
   > > 
   > > Can someone take a look the following
   > > and tell me why I'm getting errors?
   > > I'm completely baffled!
   > > ----------------------------
   > > 
   > > what=> create table bla(desc text,def text,data text);
   > > ERROR:  parser: parse error at or near "desc"
   > > what=> create table bla("desc" text,def text,data text);
   > > CREATE
   > > what=>