Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id CFE599FBE09;
	Thu, 14 Jun 2007 09:30:23 -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 18088-01; Thu, 14 Jun 2007 09:30:05 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id 3E0889FBD93;
	Thu, 14 Jun 2007 09:30:16 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from svana.org (svana.org [203.190.233.187])
	by svr4.postgresql.org (Postfix) with ESMTP id EC8C85AF02C;
	Thu, 14 Jun 2007 12:30:14 +0000 (GMT)
Received: from kleptog by svana.org with local (Exim 4.50)
	id 1HyoPE-0003aF-LY; Thu, 14 Jun 2007 22:26:28 +1000
Date: Thu, 14 Jun 2007 14:26:28 +0200
From: Martijn van Oosterhout <kleptog@svana.org>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Ashish Karalkar <ashish.karalkar@info-spectrum.com>,
	pgsql-general@postgresql.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] function to find difference between in days between two
	dates
Message-ID: <20070614122628.GB11436@svana.org>
Reply-To: Martijn van Oosterhout <kleptog@svana.org>
Mail-Followup-To: Pavel Stehule <pavel.stehule@gmail.com>,
	Ashish Karalkar <ashish.karalkar@info-spectrum.com>,
	pgsql-general@postgresql.org, pgsql-sql@postgresql.org
References: <006101c7ae4c$ed7edbd0$170211ac@LIONKING.COM>
	<162867790706140000w478d4bds4a0a2f42a8666a26@mail.gmail.com>
	<20070614111403.GA11436@svana.org>
	<162867790706140454q5e08cff6n22ed5d58748949ed@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="ADZbWkCsHQ7r3kzd"
Content-Disposition: inline
In-Reply-To: <162867790706140454q5e08cff6n22ed5d58748949ed@mail.gmail.com>
X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6
X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522  48A7 6394 F08A 0DC6 7BE6
X-PGP-Key-URL: <http://svana.org/kleptog/0DC67BE6.pgp.asc>
User-Agent: Mutt/1.5.9i
X-SA-Exim-Connect-IP: <locally generated>
X-SA-Exim-Mail-From: kleptog@svana.org
X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200706/843
X-Sequence-Number: 115666


--ADZbWkCsHQ7r3kzd
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Jun 14, 2007 at 01:54:09PM +0200, Pavel Stehule wrote:
> ># \df date_mi
>=20
> I know about it, but it's undocumented

Hrm, yet Bruce mentions it in one of his documents.

http://momjian.us/main/writings/pgsql/data_processing.pdf

It may be undocumented, but it get a lot of hits on google :)

Have a nice day,
--=20
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to l=
itigate.

--ADZbWkCsHQ7r3kzd
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFGcTP0IB7bNG8LQkwRAmH0AKCJiESKv6wy07NA3eBxr3X0iBdkIACeK9Ti
cNyGb+yOI6b3jS6zDzXaO/I=
=Kkn0
-----END PGP SIGNATURE-----

--ADZbWkCsHQ7r3kzd--