2 questions about types - Mailing list pgsql-general

From Jason Tesser
Subject 2 questions about types
Date
Msg-id AA9E9C9ACAFCA545A33A9F6E1E88353E03920B@titus.nmi.northlandministries.org
Whole thread Raw
Responses Re: 2 questions about types
List pgsql-general
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
typeand recreat everything. 
Is there a better way to do this in Postgres?

2.  The reason I had to create my own type was because record didn't ork for me when I was selecting data across
multipletables. 
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?

I am using Suse with Postgres 7.4.2  but am considering an upgrade to 8.0

Thank you,
Jason Tesser

pgsql-general by date:

Previous
From: Fred Blaise
Date:
Subject: Re: pg/plsql question
Next
From: John DeSoi
Date:
Subject: Re: Installation on XP - Permissions