Re: Finding nearest numeric value

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, Poul Møller Hansen <freebsd(at)pbnet(dot)dk>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Finding nearest numeric value
Date: 2005-08-17 16:04:23
Message-ID: 26449.1124294663@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Csaba Nagy <nagy(at)ecircle-ag(dot)com> writes:
> The only problem is that you can't use the order by/limit syntax inside
> the union queries I guess, cause the query you proposed is giving a
> syntax error.

Parentheses are your friend ;-)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message eu 2005-08-17 16:05:36 PostgreSQL 8.0.3 limiting max_connections to 64 ?
Previous Message Bruno Wolff III 2005-08-17 15:57:34 Re: Finding nearest numeric value