RE: DBD::Pg timings

2002-11-22 Thread David Duff
... that would result in fewer bytes being exchanged between client and server and less work being done generating and parsing strings. perhaps i'll try this later. David Duff Director of Research Sockeye Networks [EMAIL PROTECTED] -Original Message- From: Jason E. Stewart [mailto

confusion re converting unix times, timezones, datetime()

2002-11-15 Thread David Duff
i'm seeing some confusing results with the datetime function. with TIMEZONE set to its default value (which for me is EST), i see the following: select datetime (0); timestamp - 1970-01-01 05:00:00 (1 row) i would have expected to see 1969-12-31 19:00:00. which is my

DBD::Pg - bulk insert using copy table from STDIN question

2002-11-12 Thread David Duff
has anyone had success using an sql command like COPY foo FROM STDIN and then using the func(string, 'putline') command to send lines to the server? the pod file alludes to this capability, but i can't quite make it work. when i try to copy form STDIN, i get an error no such file or directory.