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
[email protected]
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
