Re: SQL INSERT bug with 6.5.3 and 7.0.2

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: jgotts(at)linuxsavvy(dot)com
Cc: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: SQL INSERT bug with 6.5.3 and 7.0.2
Date: 2000-06-26 04:02:48
Message-ID: 3956D5E8.C7BA58D9@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >POSITION is a SQL reserved word.
> Shouldn't the parser then also reject "position"?

No (if I read the question correctly), since double-quoted identifiers
do not conflict with reserved words. But then, as Tom pointed out, you
will have to use the double-quotes just about everywhere.

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Franck Martin 2000-06-26 05:05:14 New types in binary ?
Previous Message Tom Lane 2000-06-26 03:27:57 Re: Insert into a table with only a SERIAL