Re: [SQL] Problem inserting composite type values

2006-12-01 Thread Aaron Bono
On 12/1/06, Chris Dunworth <[EMAIL PROTECTED]> wrote: Aaron Bono wrote: On 12/1/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: > > On Fri, 1 Dec 2006, Chris Dunworth wrote: > > > Hi all -- > > > > (huge apologies if this is a duplicate post -- I sent from an > > unsubscribed email account before

Re: [SQL] Problem inserting composite type values

2006-12-01 Thread Chris Dunworth
Aaron Bono wrote: On 12/1/06, *Stephan Szabo* <[EMAIL PROTECTED] > wrote: On Fri, 1 Dec 2006, Chris Dunworth wrote: > Hi all -- > > (huge apologies if this is a duplicate post -- I sent from an > unsubscribed email account before...) > > I

Re: [SQL] Problem inserting composite type values

2006-12-01 Thread Chris Dunworth
Stephan Szabo wrote: On Fri, 1 Dec 2006, Chris Dunworth wrote: Hi all -- (huge apologies if this is a duplicate post -- I sent from an unsubscribed email account before...) I have a problem trying to INSERT INTO a table by selecting from a function that returns a composite type. (I'm runn

Re: [SQL] Problem inserting composite type values

2006-12-01 Thread Aaron Bono
On 12/1/06, Stephan Szabo <[EMAIL PROTECTED]> wrote: On Fri, 1 Dec 2006, Chris Dunworth wrote: > Hi all -- > > (huge apologies if this is a duplicate post -- I sent from an > unsubscribed email account before...) > > I have a problem trying to INSERT INTO a table by selecting from a > function

Re: [SQL] Problem inserting composite type values

2006-12-01 Thread Stephan Szabo
On Fri, 1 Dec 2006, Chris Dunworth wrote: > Hi all -- > > (huge apologies if this is a duplicate post -- I sent from an > unsubscribed email account before...) > > I have a problem trying to INSERT INTO a table by selecting from a > function that returns a composite type. (I'm running version 8.1.

[SQL] Problem inserting composite type values

2006-12-01 Thread Chris Dunworth
Hi all -- (huge apologies if this is a duplicate post -- I sent from an unsubscribed email account before...) I have a problem trying to INSERT INTO a table by selecting from a function that returns a composite type. (I'm running version 8.1.4, FYI) Basically, I have two tables. I want to r