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.