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@thebuild.com