Re: Column does not exists?

El 26/03/15 a las 14:17, Ashesh Vashi escibió:
>
>
> [Sent through mobile]
> On Mar 26, 2015 10:43 PM, Leonardo M. Ramé <l.rame@griensu.com
> <mailto:l.rame@griensu.com>> wrote:
>  >
>  > Ok, I have this table:
>  >
>  > CREATE TABLE sessions
>  > (
>  >   "SESSIONID" integer NOT NULL,
>  >   "SESSIONTIMESTAMP" character varying(45) NOT NULL,
>  >   "SESSIONDATA" character varying(200) DEFAULT NULL::character varying,
>  >   CONSTRAINT sessions_pkey PRIMARY KEY ("SESSIONID")
>  > )
>  >
>  > Now, when I do:
>  >
>  > DELETE From sessions WHERE SESSIONTIMESTAMP < '2010-01-01 10:02:02'
>  >

Hi Ashen, adding ::timestamp does not solve the problem, the issue is
solved by adding double quotes to the field name. Anyway, I would like
to know why the error.