Re: [SQL] LIMIT 1; The Integer part only

2009-09-03 Thread Christophe Pettus
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 docum

Re: [SQL] LIMIT 1; The Integer part only

2009-09-03 Thread Steve Crawford
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? Limit return to 1 record (or other specified number). Note that without ORDER BY, there is no guarantee of whi

[SQL] LIMIT 1; The Integer part only

2009-09-03 Thread bilal ghayyad
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