Re: [GENERAL] Update entire column with new date values

2006-07-27 Thread A. Kretschmer
am 27.07.2006, um 10:17:48 -0500 mailte Weiss, Kevin folgendes: > I need to update the date for each file (the "date" & "filename" > columns). However, the updated values for date are not the same for each > file (due to when the files were last modified). I can import the new > date values from a

Re: [GENERAL] Update entire column with new date values

2006-07-27 Thread Richard Huxton
Weiss, Kevin wrote: I need to update the date for each file (the "date" & "filename" columns). However, the updated values for date are not the same for each file (due to when the files were last modified). I can import the new date values from a text file containing the date and filename. Wha

[GENERAL] Update entire column with new date values

2006-07-27 Thread Weiss, Kevin
Hi all, I have a simple table which contains information about our safety files: CREATE TABLE docs ( filename varchar(256) NOT NULL, filepath varchar(256) NOT NULL, version varchar(8), date timestamp NOT NULL, docid int8 NOT NULL DEFAULT nextval('docs_docid_seq'::regclass), category v