| From: | "Eric Andrews" <eric(dot)m(dot)andrews(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Sanity check... |
| Date: | 2006-12-07 01:22:52 |
| Message-ID: | 7a4707ef0612061722u4cc99521r9bfa32a86bc08091@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a signifigant number of tables that each have a name_date
naming scheme. I want to write a function that takes a start and end
date as arguments, and optionally a name, and returns a view of all
tables joined together by the name of the supplied name, er - if
supplied. is there a better way to go about this? one question left
unanswered is how do I somehow automagically drop the view once a user
is done with it.
suggestions and comments welcomed. thanks
eric
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2006-12-07 02:22:32 | Re: Online index builds |
| Previous Message | Bill Moran | 2006-12-07 01:09:53 | Re: VACUUM and transactions in different databases |