On 24/03/2010 22:01, Karina Guardado wrote: > for example something like the following : > > *Table 9-25. Date/Time Operators* > > Operator Example Result > + date '2001-09-28' + integer '7' date '2001-10-05' > + date '2001-09-28' + interval '1 hour' timestamp '2001-09-28 01:00:00' > + date '2001-09-28' + time '03:00' timestamp '2001-09-28 03:00:00' > + interval '1 day' + interval '1 hour' interval '1 day 01:00:00' > + timestamp '2001-09-28 01:00' + interval '23 hours' timestamp > '2001-09-29 00:00:00' > + time '01:00' + interval '3 hours' time '04:00:00' > - - interval '23 hours' interval '-23:00:00' > - date '2001-10-01' - date '2001-09-28' integer '3' > - date '2001-10-01' - integer '7' date '2001-09-24' > - date '2001-09-28' - interval '1 hour' timestamp '2001-09-27 23:00:00' > - time '05:00' - time '03:00' interval '02:00:00' > - time '05:00' - interval '2 hours' time '03:00:00' > - timestamp '2001-09-28 23:00' - interval '23 hours' timestamp > '2001-09-28 00:00:00' > - interval '1 day' - interval '1 hour' interval '1 day -01:00:00' > - timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00' interval > '1 day 15:00:00' > * 900 * interval '1 second' interval '00:15:00' > * 21 * interval '1 day' interval '21 days' > * double precision '3.5' * interval '1 hour' interval '03:30:00' > / interval '1 hour' / double precision '1.5' interval '00:40:00' > > > > is it possible? or is better to use an atached file and store it ? and > what should be the data type to store a file that can be xls, doc, pdf > for example. Sorry, I still don't get it... what *exactly* are you trying to do? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general