bob,
> Hi I have a form that inserts data to the DB. One field is timestamp
> type this field is not always filled out but postgres wont accept '' or
> null and gives the error (or maybe php gives the error)..
>
> query failed: ERROR: Bad timestamp external representation '' in....
--
I see two solutions:
1) always add a timestamp with php
maybe (???) this:
$current=time(); //get current UNIX timestamp
2) use a trigger like this one and remove it from the update/insert clause
CREATE OR REPLACE FUNCTION enterdate() RETURNS trigger AS '
DECLARE
BEGIN
NEW.tstamp := now();
RETURN NEW;
END;
' LANGUAGE 'plpgsql';
CREATE TRIGGER mytrig BEFORE INSERT ON t_text
FOR EACH ROW EXECUTE PROCEDURE enterdate();
INSERT INTO t_text (id) VALUES ('2');
SELECT * FROM t_text;
-- http://dotgeek.org/guruarticles.php?guru=view&id=27
-- may 12, 2004
good luck,
joe speigle
www.sirfsup.com
