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