| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Volkan Varol <volkan(dot)varol(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: DDL question |
| Date: | 2010-01-22 15:38:00 |
| Message-ID: | 4B59C658.4090708@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 22/01/2010 15:31, Volkan Varol wrote:
[snip]
> my scenario this is unavoidable since I require it, but there may be a
> trick to reduce its overall cost.
>
> The only alternative solution I've come up with so far is to save row
> counts into the table itself using triggers. Is this reasonable or not?
That approach has been suggested in the past, and seems a viable one.
> I'm in search for a new method / syntax to combine these two queries and
> I welcome your suggestions.
Would common table expressions be any use to you? -
http://www.postgresql.org/docs/8.4/static/queries-with.html
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2010-01-22 15:48:35 | Re: Error "invalid byte sequence for encoding UTF8" on insert into BYTEA column |
| Previous Message | Volkan Varol | 2010-01-22 15:31:55 | DDL question |