Received: from bastuba.partitur.se (bastuba.partitur.se [193.219.246.194]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA72051 for ; Tue, 13 Jul 1999 08:15:48 -0400 (EDT) (envelope-from kudo@partitur.se) Received: from partitur.se (tb303.partitur.se [193.219.246.230]) by bastuba.partitur.se (8.8.8/8.8.8) with ESMTP id OAA26962 for ; Tue, 13 Jul 1999 14:15:40 +0200 (CEST) (envelope-from kudo@partitur.se) Sender: kudo@partitur.se Message-ID: <378B2DEC.84B1514A@partitur.se> Date: Tue, 13 Jul 1999 14:15:40 +0200 From: Patrik Kudo Organization: Partitur Informationsteknik X-Mailer: Mozilla 4.51 [en] (X11; I; FreeBSD 3.2-STABLE i386) X-Accept-Language: sv,en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: "quoting" column names Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi I've been using Postgres for... well, as long as I can remember ;) And aparently I've been using a column name wich is "almost reserved" (i.e. cannot be used as identifer). Since upgrading to 6.5 I nolonger can access these fields the way I've always done them. This what I've been doing: create table login (userid text, when datetime); select when from login where userid = 'xxxx'; In 6.5 I have to do: select "when" from login where userid = 'xxxx'; My question now is, should I always quote column names, just in case, or should I only quote column names that are "almost reserved"? /Kudo -- ech`echo xiun|tr nu oc|sed 'sx\([sx]\)\([xoi]\)xo un\2\1 is xg'`ol Känns det oklart? Fråga på!