Hi Leonardo: On Thu, Mar 26, 2015 at 6:12 PM, "Leonardo M. Ramé" <l.rame@xxxxxxxxxxx> wrote: > DELETE From sessions WHERE SESSIONTIMESTAMP < '2010-01-01 10:02:02' > ERROR: column "sessiontimestamp" does not exist > LINE 1: DELETE From sessions WHERE SESSIONTIMESTAMP < '2010-01-01 10... ... > DELETE From sessions WHERE "SESSIONTIMESTAMP" < '2010-01-01 10:02:02' > > It DOES work. > > Why the db doesn't recognize the name of the table without quotes?. Unquoted identifiers for several things, column names amongst them, are treated by case folding in SQL. Many DBs do it to uppercase, postgres does it to lower case ( as hinted by the column name being printed in lowercase ). So if you QUOTE an UPPERCASE name you must quote it always. As a rule of thumb, I'll recommend quoting your identifiers always or never, quoting it in some statements ( create ) and not others ( 1st delete ) will normally surprise you on unpleasant ways. Francisco Olarte. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
