| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Jason Tesser <JTesser(at)nbbc(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: 2 questions about types |
| Date: | 2005-03-16 13:51:51 |
| Message-ID: | 423839F7.6020507@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jason Tesser wrote:
> 1. i have a few funcions that depend on a type. i don't want to have to srop every function just so I can drop the type and recreat everything.
> Is there a better way to do this in Postgres?
Not really - if you're redefining the type then the functions really
have to be recreated. I try to keep related objects in the same file, so
I can re-run them all together.
> 2. The reason I had to create my own type was because record didn't ork for me when I was selecting data across multiple tables.
> I thought it should be dynamic but it only seems to work if i select all data in one table. I need 2-3 columns from multiple
> tables.
> Is there a better way to do this in Postgres?
Could you give more details of what you're trying? RECORD variables in
functions should work fine.
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vinita bansal | 2005-03-16 14:08:49 | generating statistics |
| Previous Message | David | 2005-03-16 13:17:26 | Re: plpython function problem workaround |