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@xxxxxxxxxxx <mailto:l.rame@xxxxxxxxxxx>> 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.
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
