PG sql error
dennis
27/09/2009 12:22:00SQL error:
ERROR: operator does not exist: character varying + integer
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.
In statement:
UPDATE woningaanbod SET status = 'te koop' WHERE in_verkoop_dagnr + 42 < to_char(NOW(),'DDD') AND in_verkoop_dagnr + 42 <= 366 AND status = 'nieuw in verkoop'
wie kan mij helpen
met vriendelijke groet,
dennis
ERROR: operator does not exist: character varying + integer
HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts.
In statement:
UPDATE woningaanbod SET status = 'te koop' WHERE in_verkoop_dagnr + 42 < to_char(NOW(),'DDD') AND in_verkoop_dagnr + 42 <= 366 AND status = 'nieuw in verkoop'
wie kan mij helpen
met vriendelijke groet,
dennis