Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id CDB199FB715 for ; Thu, 14 Jun 2007 09:47:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 19963-03 for ; Thu, 14 Jun 2007 09:47:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.225]) by postgresql.org (Postfix) with ESMTP id E758F9FB7BC for ; Thu, 14 Jun 2007 09:47:11 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 68so459521wri for ; Thu, 14 Jun 2007 05:47:10 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=TJr86kuowXJkiAmUdzetb2m3Zj8KhpOB0KAdQWkRCtJ13p8OCSVZW5UpQpauzo+dXwNPvgVvEdzGSo9E4ijEdehLDl8eKHIKpi57BSPvURqHCCew8JYjNU+7l5PFhJNEHlFamnMOrEtlVhGP5KdcwXhjBG4s+Btio0+CxupRi0M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=G8ft4i/z3qw7OJegz6Eh5TW314gHUyUJii8JhIwTnYluBglg1TdwR3TPTT6hYLYV3LpnIqY5pFtVdKloMMg6dl4oSYxMocrCrCKBYxDB1DeM3kiHwE3Ak9E7LeeCESZ9rpriy+swJT4xP/qBvH3mJtYowiYCKpxZlZ5unTa8Me8= Received: by 10.142.98.18 with SMTP id v18mr91415wfb.1181825229453; Thu, 14 Jun 2007 05:47:09 -0700 (PDT) Received: by 10.142.80.10 with HTTP; Thu, 14 Jun 2007 05:47:09 -0700 (PDT) Message-ID: <162867790706140547s591ed956lb93972b686e74505@mail.gmail.com> Date: Thu, 14 Jun 2007 14:47:09 +0200 From: "Pavel Stehule" To: "Martijn van Oosterhout" , "Pavel Stehule" , "Ashish Karalkar" , pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] function to find difference between in days between two dates In-Reply-To: <20070614122628.GB11436@svana.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <006101c7ae4c$ed7edbd0$170211ac@LIONKING.COM> <162867790706140000w478d4bds4a0a2f42a8666a26@mail.gmail.com> <20070614111403.GA11436@svana.org> <162867790706140454q5e08cff6n22ed5d58748949ed@mail.gmail.com> <20070614122628.GB11436@svana.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/844 X-Sequence-Number: 115667 > 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 :) > why google? look to pgsql/src/backend/utils/adt/date.c :-) Regards Pavel Stehule