| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | vinita bansal <sagivini(at)hotmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: function corresponging to over in db2 |
| Date: | 2005-01-06 12:24:19 |
| Message-ID: | 20050106122411.GA15754@svana.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jan 06, 2005 at 08:00:13AM +0000, vinita bansal wrote:
> Hi,
>
> I have a query of the form "select min(tab1.a) over(partition by tab1.b
> tab2.a tab1.c) from .....
> in db2. What will be the corresponding query for postgres. Does Postgres
> have a function which provides the same functionality??
I've never heard of it, perhaps you could explain what it does? Perhaps
input and output example?
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andre Felipe Machado | 2005-01-06 13:28:18 | postgresql-contrib risks? |
| Previous Message | Constanze Tschritter | 2005-01-06 12:15:10 | configuration problems of postgresql under windows xp |