Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id B43A0633B3C for ; Thu, 3 Sep 2009 21:49:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96300-02 for ; Fri, 4 Sep 2009 00:49:13 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from web53910.mail.re2.yahoo.com (web53910.mail.re2.yahoo.com [206.190.36.220]) by mail.postgresql.org (Postfix) with SMTP id D789D63267C for ; Thu, 3 Sep 2009 21:49:13 -0300 (ADT) Received: (qmail 8964 invoked by uid 60001); 4 Sep 2009 00:49:12 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1252025352; bh=gPUwFklXWE2gw5qOEcZe4uTLWvs60FVKjXvVaK/mXWY=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=ctMm0wGG5BbLepETGOlOV3gOZZuv+kuR+haDg92xSnL+aBLUcy0MF6dErrsXZzAbxhJHVVhwbUbIpSoEzID4YrMZDQrBGuV3RMGft8m171I5SH/oYjkKLa7HkORX0VsVdXNgf1Hv3Lohtff8dAxel4lACvrznInw5Zfi4f2dJE8= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=ab3UDortpij41tC9wMjsA4uQ6xpuVZXsukYEIXSXdBHPfmzDdVwBi2r7tD9yovOJ15PFnl5lhftprfwvWWyBA2Yyta+j9C0MLhOevxklknv+bQERyV69h+/WrIjtk4Ir1XpKb2u3MbO1XYm0FGuB0nSafm8+0aYDmMzlq+vym0s=; Message-ID: <26617.92501.qm@web53910.mail.re2.yahoo.com> X-YMail-OSG: KjvuT9EVM1kPq7AwC3CZpKWUU9zKHEKskbzPsFwI0w_qd29fLwm_LK3Qt5FB2VgLqX7kTHBVnX58rPKMMK_DPqJD1pJv6a1Wp.QN1tJeIP8Sf2E39D2TTyzZ6UyqGzQ2ACtEZfWGYw1.11hPwUFxltPLF8sdkvohAt74PeAHaSFP698NZIlx1VzTgX6A.sllwEt12ocD.f88Scds_taRKAn.NSjLhP1ALn8m4UxVXggS3bBuLbPPcWdjf66iKo1KWkvFJd5b9LBFYhZKOx6bRtexhPajLEUTm1qHsDm8ha8J0WPzLacsNoOKAt2IRbJHEXDu8ik- Received: from [62.150.150.85] by web53910.mail.re2.yahoo.com via HTTP; Thu, 03 Sep 2009 17:49:11 PDT X-Mailer: YahooMailClassic/6.1.2 YahooMailWebService/0.7.338.2 Date: Thu, 3 Sep 2009 17:49:11 -0700 (PDT) From: bilal ghayyad Subject: LIMIT 1; The Integer part only To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200909/21 X-Sequence-Number: 33086 Hello List; I have two questions: 1) When writing the function (I mean sql function) in the postgresql, I noticed the use for LIMIT 1, but did not understand what does it mean and why we use it? 2) Also in the function (the sql function) in the postgresql, if I need to take the integer part of the number, which math function can do this for me? For example, I have 3.900 and I need only the 3 (the integer part), which math function to be used? Any advise? Regards Bilal