Re: LIMIT 1; The Integer part only

On Sep 3, 2009, at 5:49 PM, bilal ghayyad wrote:
> 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?

It restricts the number of rows returned by the SELECT. You can find
the documentation here:

http://www.postgresql.org/docs/8.4/interactive/sql-select.html#SQL-LIMIT

>
> 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?

floor or trunc, depending on the behavior you want for negative numbers:

http://www.postgresql.org/docs/8.4/interactive/functions-math.html

--
-- Christophe Pettus
xof(at)thebuild(dot)com