Postgres Pro
Downloads
Home   >   mailing lists

Re: Can this be done in one query? - Mailing list pgsql-general

From Bjoern Metzdorf
Subject Re: Can this be done in one query?
Date
Msg-id 001301c1f618$2a01e5e0$0564a8c0@toolteam.net
Whole thread Raw
In response to Can this be done in one query?  (Randall Perry <rgp@systame.com>)
List pgsql-general
Tree view 
> So, is there a way to do this in one query without creating a temp table?

How about a view:

create view test as select max(date) from log order by date_time desc limit
12;

select max(date) from test;

Greetings,
Bjoern

pgsql-general by date:

Previous
From: Darren Ferguson
Date:
Subject: Re: NOT IN query issues
Next
From: "Samuel J. Sutjiono"
Date:
Subject: Performance issues with compaq server