On Thu, 6 Oct 2011, David Johnston wrote:
Missing the FROM before chemistry
D'oh! Obviously not yet sufficiently cafinated this morning.
Also, with the window function can I limit the output to a single str_name
and param?
Not directly. After you create the windowed result you can turn it into a
sub-query and filter that. The other form suggested (where quant = select
max(quant) from chemistry where ...) is probably a better performer though
for your need - I did't read the subject line closely enough and my two
options don't directly give you what you are looking for. Though era ing
the window query and then adding a (where quant_max = quant) clause would
get you closer; quant_max being the column alias for the window
expression.
Ah.
Thanks, David,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
