| From: | Murali Mohan Kasetty <kasetty(at)india(dot)hp(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Dynamic limit for the number of records? |
| Date: | 2002-10-05 10:43:37 |
| Message-ID: | 3D9EC259.38AC3D40@india.hp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi all,
Is there a way to dynamically limit the number of records in a view
based on
the number of records in another table. Her e is an example:
I have two views VIEW1 and VIEW2.
The total number of records in VIEW1 and VIEW2 should be 20. So, if
VIEW1
has 10 records VIEW2 should have only 20 records, if VIEW1 has 5 records
then VIEW2 should have only 25 records.
I have tried LIMIT to limit the number of records. BUt, LIMIT requires
that
the number of recors be static. A
If somebody has faced this situation and knows of a solution, please let
me
know.
Best Regards
- Geetha
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051382 (Phone)
847 1382 (HP Telnet)
----------------------------------------------------
| Attachment | Content-Type | Size |
|---|---|---|
| kasetty.vcf | text/x-vcard | 339 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2002-10-05 13:50:50 | Server locale? |
| Previous Message | Jeff Davis | 2002-10-05 09:41:15 | Re: Boolean output format |