Re: [SQL] 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 x...@thebuild.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Union Question
On Dec 3, 2010, at 9:04 AM, Shaun McCloud wrote: > I’m trying that, but I am getting an error that says “ERROR: function > dblink_connect(unknown, unknown) does not exist” dblink is a contrib module, and needs to be installed before use: http://www.postgresql.org/docs/9.0/interactive/dblink.html -- -- Christophe Pettus x...@thebuild.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
Re: [SQL] Union Question
On Dec 3, 2010, at 9:08 AM, Shaun McCloud wrote: > That would be nice to see in the documentation for dblink It's true of all contrib modules; that's mentioned at the start of the contrib section: http://www.postgresql.org/docs/9.0/interactive/contrib.html -- -- Christophe Pettus x...@thebuild.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
