Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 7ABA99F9A73 for ; Sun, 9 Sep 2007 08:01:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 14153-02 for ; Sun, 9 Sep 2007 08:01:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.189]) by postgresql.org (Postfix) with ESMTP id 3ABA39F955D for ; Sun, 9 Sep 2007 08:01:54 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id l15so746195rvb for ; Sun, 09 Sep 2007 04:01:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=7D66EbCv3f44FCiyeA+66glP12eGeCV7D5GhwHkSXAI=; b=OEbQsy7hpig4nVkcxKkDYV6eV1YpWZsq/8lbP0zVm8seFjdlBfGWDFJT2eTLO7Qjlq3cXZAgbswxcAL1b3EiAS9vUlGw6gby7uzEii7jb71Yx8c6BfTxS9zbjkmMgyOAFBcV/74hmemJjVMHBjZAqawtOttHuOeV47JStAwuank= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=T5aNGIANM+/LGe6EO8TkJTGT6s2xh2tgK363ZQYOJ3fQu2KoLI0naZHDZEa/31Mm2XTZApmJ6OU0nonIDqoSFImGg4o8ufHh3sYZ9QHLdsKGMEmpCW5HvgRTkL4bbXkxsLdadmZX7mgMZrD7dxzNg8q8/13zVPMwt8c5izshtpg= Received: by 10.141.197.18 with SMTP id z18mr1247043rvp.1189335712913; Sun, 09 Sep 2007 04:01:52 -0700 (PDT) Received: by 10.140.187.9 with HTTP; Sun, 9 Sep 2007 04:01:52 -0700 (PDT) Message-ID: <92869e660709090401m37431819s630ae5c748c6fc76@mail.gmail.com> Date: Sun, 9 Sep 2007 12:01:52 +0100 From: "=?UTF-8?Q?Filip_Rembia=C5=82kowski?=" To: novice Subject: Re: work hour calculations Cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline References: <92869e660709070513t7d19e836sb6a4543e6beb3b0b@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/404 X-Sequence-Number: 120327 MjAwNy85LzksIG5vdmljZSA8dXNlci5wb3N0Z3Jlc3FsQGdtYWlsLmNvbT46Cj4gPiA+ID4gVGhl IHJlc3VsdCBJJ20gZXhwZWN0aW5nIGZvciB0aGUgYWJvdmUgdG8gYmUKPiA+ID4gPgo+ID4gPiA+ ICAgIG5vdGlmaWNhdGlvbl90aW1lICAgIHwgICAgIGZpbmlzaGVkX3RpbWUgICAgICB8ICAgICBh Y3R1YWwKPiA+ID4gPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tCj4gPiA+ID4gIDIwMDctMDctMDYgMTU6NTA6MDArMTAg fCAyMDA3LTA3LTA5IDA3OjEwOjAwKzEwIHwgMDE6MjA6MDAKPiA+ID4gPiAgMjAwNy0wNy0wNyAx MjozMDowMCsxMCB8IDIwMDctMDctMDkgMDc6MjA6MDArMTAgfCAwMDoyMDowMAo+ID4KPgo+IGNy ZWF0ZSB0YWJsZSBsb2cKPiAoCj4gaWQgaW50ZWdlciBQUklNQVJZIEtFWSwKPiBub3RpZmljYXRp b25fdGltZSB0aW1lc3RhbXAgd2l0aCB0aW1lIHpvbmUsCj4gZmluaXNoZWRfdGltZSB0aW1lc3Rh bXAgd2l0aCB0aW1lIHpvbmUKPiApOwo+Cj4gSU5TRVJUIElOVE8gbG9nIHZhbHVlcyAoMSwgJzIw MDctMDctMDYgMTU6NTAnLCAnMjAwNy0wNy0wOSAwNzoxMCcpOwo+IElOU0VSVCBJTlRPIGxvZyB2 YWx1ZXMgKDIsICcyMDA3LTA3LTA3IDEyOjMwJywgJzIwMDctMDctMDkgMDc6MjAnKTsKPgo+IFNF TEVDVCBub3RpZmljYXRpb25fdGltZSwgZmluaXNoZWRfdGltZSwgc3VtKGZpbmlzaGVkX3RpbWUg LQo+IG5vdGlmaWNhdGlvbl90aW1lKSBhcyBhY3R1YWwKPiBGUk9NIGxvZwo+IEdST1VQIEJZIG5v dGlmaWNhdGlvbl90aW1lLCBmaW5pc2hlZF90aW1lOwo+CgpPSy4gc28gSSBoYXZlIGJhZCBuZXdz IGZvciB5b3U6IHdpdGggc3VjaCBzdHJ1Y3R1cmUsIHlvdSB3aWxsIGhhdmUgdG8Kd3JpdGUgc29t ZSBmdW5jdGlvbiB0byBjYWxjdWxhdGUgd29yayB0aW1lIHNwZW50IGZvciBlYWNoIHRhc2suCgpn ZW5lcmFsIGFsZ29yaXRobSB3b3VsZCBiZSBzaW1pbGFyIHRvCgoqIHRha2UgdGhlIG5vdGlmaWNh dGlvbiB0aW1lCiogdGFrZSB0aGUgZmluaXNoZWRfdGltZQoqIHNldCBwb2ludGVyIDo9IG5vdGlm LiB0aW1lCiogc2V0IGFjdHVhbCA6PSAwCiogd2hpbGUgdGhlcmUgaXMgYW55IHdlZWtlbmQgYmV0 d2VlbiB0aGUgcG9pbnRlciBhbmQgIGZpbmlzaGVkX3RpbWUsCmRvIHRoZSBmb2xsb3dpbmcKKiog c2V0IGFjdHVhbCA6PSBhY3R1YWwgKyAoIHdlZWtlbmQgYmVnaW4gLSBwb2ludGVyICkKKiogbW92 ZSBwb2ludGVyIHRvIHRoZSBuZXh0IG1vbmRheSBtb3JuaW5nCiogc2V0IGFjdHVhbCA6PSBhY3R1 YWwgKyAoIGZpbmlzaGVkX3RpbWUgLSBwb2ludGVyICkKCkJVVDoKdGhpcyBpcyB1Z2x5LgpkbyB5 b3UgYWx3YXlzIGFzc3VtZSB0aGF0IHBlb3BsZSBhcmUgZG9pbmcgT05MWSBvbmUgdGFzayBhdCBh IHRpbWU/CgptYXliZSB0aGluayBvZiByZXByZXNlbnRpbmcgd29yayBzaGVldHMgaW4gdGhlIGRh dGFiYXNlPwoKbWF5YmUgdGhpbmsgb2YgYWRkaW5nICJ3b3JrX3RpbWUiIGZpZWxkIHRvIHlvdXIg dGFibGUgKHdoeSBub3QgdHJ1c3QKcGVvcGxlLCB0aGV5IGtub3cgYmVzdCkKCm1heWJlIHRoZSBh cHBsaWNhdGlvbiB5b3UgdXNlIGZvciBlbnRlcmluZyBkYXRhIGNvdWxkIGdpdmUgc29tZSAiaGlu dCIKYmFzaW5nIG9uIGFib3ZlIGFsZ28uCgoKZ29vZCBsdWNrLAoKCgotLSAKRmlsaXAgUmVtYmlh xYJrb3dza2kK