From: bilal ghayyad <bilmar_gh@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: LIMIT 1; The Integer part only
Date: Thu, 3 Sep 2009 17:49:11 -0700 (PDT)
Message-ID: <26617.92501.qm@web53910.mail.re2.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bilmar_gh@yahoo.com
Subject: Re: LIMIT 1; The Integer part only
In-Reply-To: <26617.92501.qm@web53910.mail.re2.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox