Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 412259FBE14 for ; Thu, 14 Jun 2007 08:54:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 84071-01 for ; Thu, 14 Jun 2007 08:54:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.235]) by postgresql.org (Postfix) with ESMTP id BA8199FB929 for ; Thu, 14 Jun 2007 08:54:11 -0300 (ADT) Received: by nz-out-0506.google.com with SMTP id m22so456934nzf for ; Thu, 14 Jun 2007 04:54: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=scoXkImKnGo1OefgWphiOGVQTn2WYKh6LD0eNGkYHv8ezNOBEVBxUZ3yKUvIU8IAVoUAdhNav2WuKgA6py56yJKee268gm/v9e4fb5vi4adGdmREZR8kMBvmtwlMtYd2Gv/X7Mb6YbHcez7YXJsp1kxwPPHXeUF+EhLa7POeuIg= 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=DYYBXSpx0+FpG6nun04hSHpvNnhxT54/+epbUucMVa++oUYZGOXwgR3Hem9CSKQh1/JQVRtsKogyKoqHe9DIat9EJYZUNULcHiT/gWAG0wBU07mtbVHJ4CYGBSD3k7yBwKtJxkITqOjM+oo75VjT/mlK5RiCP+dWckT5ZhDr59U= Received: by 10.143.163.21 with SMTP id q21mr90347wfo.1181822049838; Thu, 14 Jun 2007 04:54:09 -0700 (PDT) Received: by 10.142.80.10 with HTTP; Thu, 14 Jun 2007 04:54:09 -0700 (PDT) Message-ID: <162867790706140454q5e08cff6n22ed5d58748949ed@mail.gmail.com> Date: Thu, 14 Jun 2007 13:54: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: <20070614111403.GA11436@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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/840 X-Sequence-Number: 115663 2007/6/14, Martijn van Oosterhout : > On Thu, Jun 14, 2007 at 09:00:12AM +0200, Pavel Stehule wrote: > > Hello > > > > PostgreSQL hasn't any official function for it. If you need it, you > > can write own function > > Not true. Anything that is done by an operator as actually done by a > function. So the function exists: > > # \df date_mi > List of functions I know about it, but it's undocumented Pavel