Re: [GENERAL] select as params to function

2012-02-17 Thread Andy Colson
On 2/17/2012 2:49 PM, Merlin Moncure wrote: On Fri, Feb 17, 2012 at 2:32 PM, Andy Colson wrote: On 2/17/2012 2:11 PM, Pavel Stehule wrote: Hello PostgreSQL has no table data type. You can use a array of records instead and then select fx((select array(select * from tab))); select fx(arra

Re: [GENERAL] select as params to function

2012-02-17 Thread Merlin Moncure
On Fri, Feb 17, 2012 at 2:32 PM, Andy Colson wrote: > On 2/17/2012 2:11 PM, Pavel Stehule wrote: >> >> Hello >> >> PostgreSQL has no table data type. You can use a array of records instead >> >> and then >> >> select fx((select array(select * from tab))); select fx(array(select t from tab t)); f

Re: [GENERAL] select as params to function

2012-02-17 Thread Andy Colson
On 2/17/2012 2:11 PM, Pavel Stehule wrote: Hello PostgreSQL has no table data type. You can use a array of records instead and then select fx((select array(select * from tab))); regards Pavel Stehule 2012/2/17 Andy Colson: Hi all, Trying to clean up some data so I wrote myself a function

Re: [GENERAL] select as params to function

2012-02-17 Thread Pavel Stehule
Hello PostgreSQL has no table data type. You can use a array of records instead and then select fx((select array(select * from tab))); regards Pavel Stehule 2012/2/17 Andy Colson : > Hi all, > > Trying to clean up some data so I wrote myself a function which will insert > the new stuff okay b

[GENERAL] select as params to function

2012-02-17 Thread Andy Colson
Hi all, Trying to clean up some data so I wrote myself a function which will insert the new stuff okay but the existing data... I'm not sure how to run it through the function. To make life a little simpler on myself, the old data is in table webserv2 and the new data will go into table webs