Re: More reserved words

[Jim McBeath <jimmc@xxxxxxxxxxxxxxx>]

On Tue, Feb 25, 2003 at 11:41:29AM -0600, Aaron Westendorf wrote:
> In the past, "TableName.columnName" has been successful.
> 
> -Aaron

For compatibility with other databases, you should use
"TableName"."columnName" rather than putting it all inside one set of
quotes.  While Mckoi parses the latter as separate table and column names,
other databases parse it as a single table or column name containing a
dot in the middle.

-Jim

> M. A. Sridhar wrote:
> > Hello folks,
> > 
> > I just tried to create a database from a client's relatively large schema
> > (300 tables) and discovered three more Mckoi reserved words: COUNT, TIME and
> > USAGE. The client's tables include columns with these names, but the Mckoi
> > engine doesn't like them.
> > 
> > Any workarounds?