Re: [BUGS] TYPE of TEMP table does not seem to get set

2012-04-16 Thread Bill MacArthur
On 4/16/2012 4:29 PM, Bill MacArthur wrote: On 4/16/2012 4:11 PM, Tom Lane wrote: Bill MacArthur writes: I have a view "configurations.tp_transactions" which is a blend of many tables using INNER and LEFT JOINs. I want to populate a temp table from which I can obtain the data and programmat

Re: [BUGS] TYPE of TEMP table does not seem to get set

2012-04-16 Thread Bill MacArthur
On 4/16/2012 4:11 PM, Tom Lane wrote: Bill MacArthur writes: I have a view "configurations.tp_transactions" which is a blend of many tables using INNER and LEFT JOINs. I want to populate a temp table from which I can obtain the data and programmatically write queries to operate on that data u

Re: [BUGS] TYPE of TEMP table does not seem to get set

2012-04-16 Thread Tom Lane
Bill MacArthur writes: > I have a view "configurations.tp_transactions" which is a blend of many > tables using INNER and LEFT JOINs. I want to populate a temp table from which > I can obtain the data and programmatically write queries to operate on that > data using certain PLPGSQL functions i

[BUGS] TYPE of TEMP table does not seem to get set

2012-04-16 Thread Bill MacArthur
Hello, I am hoping that I'm just missing some kind of syntax tweak, but after experimenting a bit, I cannot seem to get this working. I have a view "configurations.tp_transactions" which is a blend of many tables using INNER and LEFT JOINs. I want to populate a temp table from which I can obtai