Re: [GENERAL] interval hour to minute or interval day to minute

2011-06-18 Thread Noah Misch
On Thu, Jun 16, 2011 at 06:07:50PM -0400, Bruce Momjian wrote: Noah Misch wrote: On Sun, Apr 17, 2011 at 04:55:51PM +0100, Jack Douglas wrote: I discovered the 'fields' option of 'interval', but i can't figure out from the docs how it is supposed to work. Are hour to minute and day

Re: [GENERAL] interval hour to minute or interval day to minute

2011-06-16 Thread Bruce Momjian
Noah Misch wrote: On Sun, Apr 17, 2011 at 04:55:51PM +0100, Jack Douglas wrote: I discovered the 'fields' option of 'interval', but i can't figure out from the docs how it is supposed to work. Are hour to minute and day to minute really the same thing? And if not, in what circumstances

Re: [GENERAL] interval hour to minute or interval day to minute

2011-05-09 Thread Noah Misch
On Sun, Apr 17, 2011 at 04:55:51PM +0100, Jack Douglas wrote: I discovered the 'fields' option of 'interval', but i can't figure out from the docs how it is supposed to work. Are hour to minute and day to minute really the same thing? And if not, in what circumstances are they treated

[GENERAL] interval hour to minute or interval day to minute

2011-04-17 Thread Jack Douglas
Hi I discovered the 'fields' option of 'interval', but i can't figure out from the docs how it is supposed to work. Are hour to minute and day to minute really the same thing? And if not, in what circumstances are they treated differently? psql (8.4.7) Type help for help. postgres= select