Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 283FF64FC08 for ; Mon, 13 Oct 2008 06:32:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 11838-08 for ; Mon, 13 Oct 2008 06:32:34 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gx0-f16.google.com (mail-gx0-f16.google.com [209.85.217.16]) by postgresql.org (Postfix) with ESMTP id F086464FCC0 for ; Mon, 13 Oct 2008 06:32:33 -0300 (ADT) Received: by gxk9 with SMTP id 9so2541141gxk.19 for ; Mon, 13 Oct 2008 02:32:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=97TCxv3MdhQ7VAG0uiVBOhroSGBdctuWflOshn0MelI=; b=kT8xwNaMtICCmc3RHTx/ZbV0nfaCYiiyB4/JUR3Uacw1zvq/Kao7G/vLh+KDrQlBAQ SzthpcTxzAyAggrebAAQ0qunr3wy9kPW8eLeaw+r5VjeiQo2pMgFsEr6VQsPeBd9yYQa S5quT+JOwR0vuPKThBwn+DQah3i9Wua/MhmqE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=aBTfSmalT9zDpoUv3h3/6XYe900tA4ID4z6K7XkHmTVCWiyJayu8ilmDnSxvoxjY91 3KMXEH0OpayKL4mxYH6czf0qqcwyNLR+sSkX8Mf1HRQ77HXpm8ATDH1O0C/zlcNry2Co 1Pc+9jJ+j+eaAZrPjvXmi9w5UtZKevipdIH6Q= Received: by 10.142.226.3 with SMTP id y3mr2488147wfg.56.1223890350638; Mon, 13 Oct 2008 02:32:30 -0700 (PDT) Received: by 10.142.11.3 with HTTP; Mon, 13 Oct 2008 02:32:30 -0700 (PDT) Message-ID: Date: Mon, 13 Oct 2008 17:32:30 +0800 From: "Wilhansen Li" To: pgsql-interfaces@postgresql.org Subject: Re: Timestamp with libpq In-Reply-To: <1223884381.3502.10.camel@vie063.fabagl.fabasoft.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_109371_8158612.1223890350630" References: <1223884381.3502.10.camel@vie063.fabagl.fabasoft.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200810/4 X-Sequence-Number: 6805 ------=_Part_109371_8158612.1223890350630 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline QWN0dWFsbHksIEkndmUgZG9uZSB0aGlzIGJlZm9yZS4gQW5kLCB1aCwgeW91IGNhbiBjaGVjayBv dXQgbXkgYmxvZyBmb3IKZGV0YWlsczoKCmh0dHA6Ly9ibG9ncy5jcmFtbWVyei1pbmMubmV0L3Ro dW5rLzIwMDcvMDUvMDkvZ3JhYmJpbmdfdGltZV9pbl9wb3N0Z3Jlc3FsX3VzaW5nX2xpYnBxCk9u IE1vbiwgT2N0IDEzLCAyMDA4IGF0IDM6NTMgUE0sIEpha29iIExlY2huZXIgPGpha29iLmxlY2hu ZXJAYXBwbHN0cnVkbC5jb20KPiB3cm90ZToKCj4gSGVsbG8gZXZlcnlib2R5LAo+Cj4gSSdtIHRy eWluZyB0byBjb252ZXJ0IHRpbWVzdGFtcCB2YWx1ZXMgcmV0dXJuZWQgYnkgYW4gU1FMIHF1ZXJ5 IGludG8gYW4KPiB1bml4IHRpbWVfdC4gSSdtIHVzaW5nIHRoZSBsaWJwcSBsaWJyYXJ5Lgo+Cj4g Rm9yIGV4ZWN1dGluZyB0aGUgcXVlcnkgSSB1c2UgIlBRZXhlY1BhcmFtcyIgd2l0aCB0aGUgcGFy YW1ldGVyCj4gInJlc3VsdEZvcm1hdCIgc2V0IHRvIDEgaW4gb3JkZXIgdG8gb2J0YWluIHJlc3Vs dHMgaW4gYmluYXJ5IGZvcm1hdC4KPgo+IFRoZSB0YWJsZSBJJ20gZmV0Y2hpbmcgZGF0YSBmcm9t IHdhcyBjcmVhdGVkIHdpdGggdGhlIGZvbGxvd2luZwo+IHN0YXRlbWVudDoKPiBjcmVhdGUgdGFi bGUgdGVzdHRhYmxlIChjIHRpbWVzdGFtcCk7Cj4KPiBUaGUgc3RhdGVtZW50IGV4ZWN1dGVkIGJ5 ICJQUWV4ZWNQYXJhbXMiIGlzIGEgc2ltcGxlICJzZWxlY3QiLXN0YXRlbWVudDoKPiBzZWxlY3Qg KiBmcm9tIHRlc3R0YWJsZTsKPgo+Cj4gSSd2ZSByZWFkIHRoYXQgcG9zdGdyZXMgaW50ZXJuYWxs eSBoYW5kbGVzIHRpbWVzdGFtcHMgYXMgZG91YmxlIG51bWJlcnMsCj4gd2hlcmUgdGhlIHRpbWVz dGFtcCBpcyByZXByZXNlbnRlZCBpbiBzZWNvbmRzIHNpbmNlIDIwMDAtMDEtMDEuCj4gVGh1cywg SSBhc3N1bWVkIHRoZSBkYXRhIHJldHVybmVkIGJ5ICJQUWdldHZhbHVlIiBmb3IgdGhlIHRpbWVz dGFtcAo+IGZpZWxkIGlzIGVuY29kZWQgaW4gdGhpcyBmb3JtYXQuIFRoZW4gSSB3cm90ZSBhIGxp dHRsZSByb3V0aW5lLCB3aGljaAo+IHRha2VzIHRoZSBkb3VibGUgbnVtYmVyIG9idGFpbmVkIGZy b20gIlBRZ2V0dmFsdWUiIGFuZCBjb252ZXJ0cyBpdCBpbnRvCj4gYW4gdW5peCB0aW1lX3QuIFRo aXMgd29ya3MgcGVyZmVjdGx5IGlmIHRoZSBwb3N0Z3JlcyBzZXJ2ZXIgKHZlcnNpb24KPiA4LjEu NC0xLjEpIHJ1bnMgb24gUkhFTCBidXQgaWYgSSBxdWVyeSB0aGUgZGF0YSBmcm9tIGEgcG9zdGdy ZXMgc2VydmVyCj4gKHZlcnNpb24gOC4xLjQtMS4zKSBydW5ubmluZyBvbiBTTEVTIHRoZSByZXN1 bHQgdG90YWxseSB3cm9uZy4KPgo+IEFueSBpZGVhcz8KPgo+IEJlc3QgcmVnYXJkcwo+IEpha29i IExlY2huZXIKPgo+Cj4gLS0KPiBKYWtvYiBMZWNobmVyCj4gUmVzZWFyY2ggJiBEZXZlbG9wbWVu dAo+IGFwcGwuc3RydWRsIFNvZnR3YXJlIEdtYkgKPiBIb25hdWVyc3RyYcOfZSA0Cj4gQS00MDIw IExpbnoKPiBUZWwuOiBbKzQzXSAoNzApIDYwIDYxIDYyCj4gRmF4OiBbKzQzXSAoNzApIDYwIDYx IDYyLTYwOQo+IEUtTWFpbDogamFrb2IubGVjaG5lckBhcHBsc3RydWRsLmNvbQo+IFdlYjogaHR0 cDovL3d3dy5hcHBsc3RydWRsLmNvbQo+IEhhbmRlbHNnZXJpY2h0IExpbnosIEZOIDMwMzk4OCB0 Cj4KPiAtLQo+IFNlbnQgdmlhIHBnc3FsLWludGVyZmFjZXMgbWFpbGluZyBsaXN0IChwZ3NxbC1p bnRlcmZhY2VzQHBvc3RncmVzcWwub3JnKQo+IFRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNj cmlwdGlvbjoKPiBodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWludGVy ZmFjZXMKPgoKCgotLSAKTGlmZSBpcyB0b28gc2hvcnQgZm9yIGRpYWwtdXAuCg== ------=_Part_109371_8158612.1223890350630 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: base64 Content-Disposition: inline PGRpdiBkaXI9Imx0ciI+PGJyPjxwPkFjdHVhbGx5LCBJJiMzOTt2ZSBkb25lIHRoaXMgYmVmb3Jl LiBBbmQsIHVoLCB5b3UgY2FuIGNoZWNrIG91dCBteSBibG9nIGZvciBkZXRhaWxzOjxicj48L3A+ PHA+PGEgaHJlZj0iaHR0cDovL2Jsb2dzLmNyYW1tZXJ6LWluYy5uZXQvdGh1bmsvMjAwNy8wNS8w OS9ncmFiYmluZ190aW1lX2luX3Bvc3RncmVzcWxfdXNpbmdfbGlicHEiPmh0dHA6Ly9ibG9ncy5j cmFtbWVyei1pbmMubmV0L3RodW5rLzIwMDcvMDUvMDkvZ3JhYmJpbmdfdGltZV9pbl9wb3N0Z3Jl c3FsX3VzaW5nX2xpYnBxPC9hPjwvcD4KPGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPk9uIE1vbiwg T2N0IDEzLCAyMDA4IGF0IDM6NTMgUE0sIEpha29iIExlY2huZXIgPHNwYW4gZGlyPSJsdHIiPiZs dDs8YSBocmVmPSJtYWlsdG86amFrb2IubGVjaG5lckBhcHBsc3RydWRsLmNvbSI+amFrb2IubGVj aG5lckBhcHBsc3RydWRsLmNvbTwvYT4mZ3Q7PC9zcGFuPiB3cm90ZTo8YnI+PGJsb2NrcXVvdGUg Y2xhc3M9ImdtYWlsX3F1b3RlIiBzdHlsZT0ibWFyZ2luOjAgMCAwIC44ZXg7Ym9yZGVyLWxlZnQ6 MXB4ICNjY2Mgc29saWQ7cGFkZGluZy1sZWZ0OjFleDsiPgpIZWxsbyBldmVyeWJvZHksPGJyPgo8 YnI+CkkmIzM5O20gdHJ5aW5nIHRvIGNvbnZlcnQgdGltZXN0YW1wIHZhbHVlcyByZXR1cm5lZCBi eSBhbiBTUUwgcXVlcnkgaW50byBhbjxicj4KdW5peCB0aW1lX3QuIEkmIzM5O20gdXNpbmcgdGhl IGxpYnBxIGxpYnJhcnkuPGJyPgo8YnI+CkZvciBleGVjdXRpbmcgdGhlIHF1ZXJ5IEkgdXNlICZx dW90O1BRZXhlY1BhcmFtcyZxdW90OyB3aXRoIHRoZSBwYXJhbWV0ZXI8YnI+CiZxdW90O3Jlc3Vs dEZvcm1hdCZxdW90OyBzZXQgdG8gMSBpbiBvcmRlciB0byBvYnRhaW4gcmVzdWx0cyBpbiBiaW5h cnkgZm9ybWF0Ljxicj4KPGJyPgpUaGUgdGFibGUgSSYjMzk7bSBmZXRjaGluZyBkYXRhIGZyb20g d2FzIGNyZWF0ZWQgd2l0aCB0aGUgZm9sbG93aW5nPGJyPgpzdGF0ZW1lbnQ6PGJyPgpjcmVhdGUg dGFibGUgdGVzdHRhYmxlIChjIHRpbWVzdGFtcCk7PGJyPgo8YnI+ClRoZSBzdGF0ZW1lbnQgZXhl Y3V0ZWQgYnkgJnF1b3Q7UFFleGVjUGFyYW1zJnF1b3Q7IGlzIGEgc2ltcGxlICZxdW90O3NlbGVj dCZxdW90Oy1zdGF0ZW1lbnQ6PGJyPgpzZWxlY3QgKiBmcm9tIHRlc3R0YWJsZTs8YnI+Cjxicj4K PGJyPgpJJiMzOTt2ZSByZWFkIHRoYXQgcG9zdGdyZXMgaW50ZXJuYWxseSBoYW5kbGVzIHRpbWVz dGFtcHMgYXMgZG91YmxlIG51bWJlcnMsPGJyPgp3aGVyZSB0aGUgdGltZXN0YW1wIGlzIHJlcHJl c2VudGVkIGluIHNlY29uZHMgc2luY2UgMjAwMC0wMS0wMS48YnI+ClRodXMsIEkgYXNzdW1lZCB0 aGUgZGF0YSByZXR1cm5lZCBieSAmcXVvdDtQUWdldHZhbHVlJnF1b3Q7IGZvciB0aGUgdGltZXN0 YW1wPGJyPgpmaWVsZCBpcyBlbmNvZGVkIGluIHRoaXMgZm9ybWF0LiBUaGVuIEkgd3JvdGUgYSBs aXR0bGUgcm91dGluZSwgd2hpY2g8YnI+CnRha2VzIHRoZSBkb3VibGUgbnVtYmVyIG9idGFpbmVk IGZyb20gJnF1b3Q7UFFnZXR2YWx1ZSZxdW90OyBhbmQgY29udmVydHMgaXQgaW50bzxicj4KYW4g dW5peCB0aW1lX3QuIFRoaXMgd29ya3MgcGVyZmVjdGx5IGlmIHRoZSBwb3N0Z3JlcyBzZXJ2ZXIg KHZlcnNpb248YnI+CjguMS40LTEuMSkgcnVucyBvbiBSSEVMIGJ1dCBpZiBJIHF1ZXJ5IHRoZSBk YXRhIGZyb20gYSBwb3N0Z3JlcyBzZXJ2ZXI8YnI+Cih2ZXJzaW9uIDguMS40LTEuMykgcnVubm5p bmcgb24gU0xFUyB0aGUgcmVzdWx0IHRvdGFsbHkgd3JvbmcuPGJyPgo8YnI+CkFueSBpZGVhcz88 YnI+Cjxicj4KQmVzdCByZWdhcmRzPGJyPgpKYWtvYiBMZWNobmVyPGJyPgo8YnI+Cjxicj4KLS08 YnI+Ckpha29iIExlY2huZXI8YnI+ClJlc2VhcmNoICZhbXA7IERldmVsb3BtZW50PGJyPgphcHBs LnN0cnVkbCBTb2Z0d2FyZSBHbWJIPGJyPgpIb25hdWVyc3RyYcOfZSA0PGJyPgpBLTQwMjAgTGlu ejxicj4KVGVsLjogWys0M10gKDcwKSA2MCA2MSA2Mjxicj4KRmF4OiBbKzQzXSAoNzApIDYwIDYx IDYyLTYwOTxicj4KRS1NYWlsOiA8YSBocmVmPSJtYWlsdG86amFrb2IubGVjaG5lckBhcHBsc3Ry dWRsLmNvbSI+amFrb2IubGVjaG5lckBhcHBsc3RydWRsLmNvbTwvYT48YnI+CldlYjogPGEgaHJl Zj0iaHR0cDovL3d3dy5hcHBsc3RydWRsLmNvbSIgdGFyZ2V0PSJfYmxhbmsiPmh0dHA6Ly93d3cu YXBwbHN0cnVkbC5jb208L2E+PGJyPgpIYW5kZWxzZ2VyaWNodCBMaW56LCBGTiAzMDM5ODggdDxi cj4KPGZvbnQgY29sb3I9IiM4ODg4ODgiPjxicj4KLS08YnI+ClNlbnQgdmlhIHBnc3FsLWludGVy ZmFjZXMgbWFpbGluZyBsaXN0ICg8YSBocmVmPSJtYWlsdG86cGdzcWwtaW50ZXJmYWNlc0Bwb3N0 Z3Jlc3FsLm9yZyI+cGdzcWwtaW50ZXJmYWNlc0Bwb3N0Z3Jlc3FsLm9yZzwvYT4pPGJyPgpUbyBt YWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3JpcHRpb246PGJyPgo8YSBocmVmPSJodHRwOi8vd3d3 LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWludGVyZmFjZXMiIHRhcmdldD0iX2JsYW5r Ij5odHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLWludGVyZmFjZXM8L2E+ PGJyPgo8L2ZvbnQ+PC9ibG9ja3F1b3RlPjwvZGl2Pjxicj48YnIgY2xlYXI9ImFsbCI+PGJyPi0t IDxicj5MaWZlIGlzIHRvbyBzaG9ydCBmb3IgZGlhbC11cC48YnI+CjwvZGl2Pgo= ------=_Part_109371_8158612.1223890350630--