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/

Reply via email to