Thanks for the pointers. I did figure out
'yyyy-mm-dd'::date
'hh:mm:ss'::time
And I also came up with
(date_column::text || ' ' || time_column::text)::timestamp
Which is too ugly for words. I appreciate the more elegant solutions
posted to the list.
I'm growing to like Postgres, but I'm not sure I'll ever get over DB/2 :-)
Andy
begin:vcard
fn:Andrew T. Robinson, CISM, CISSP
n:Robinson;Andrew
org:NMI InfoSecurity Solutions
adr:;;145 Newbury Street Second Floor;Portland;ME;04101;USA
email;internet:[EMAIL PROTECTED]
title:President
tel;work:207-780-6381 x226
tel;fax:207-780-6301
x-mozilla-html:TRUE
url:http://www.nmi.net
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/