Re: select into - Mailing list pgsql-sql

Hi Adrian,<br /><br />Thanks very much for your help...it is a pity you can't do this in plpgsql coz i have almost
everything else I need, and I hate to use yet another language. What does it take to add this mechanism to the
language?Is any one planning to add it? It can come it handy I bet.<br /><br />Thanks again,<br /><br />Mustafa...<br
/><br/><br /><br /><b><i>Adrian Klaver <aklaver@comcast.net></i></b> wrote:<blockquote class="replbq"
style="border-left:2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> On Sunday 26 November 2006 02:45
pm,Adrian Klaver wrote:<br /><br />><br />> I am afraid I can't make it work either.<br />I could not make it
workwith pl/pgsql, but I did manage to come up with a <br />solution using pl/pythonu.<br />The function is as
follows-<br/><br />CREATE OR REPLACE FUNCTION dat_col_py(text) RETURNS text AS<br />$Body$<br />tbl_name=args[0]<br
/>cols=plpy.prepare("selectcolumn_name from information_schema.columns where\<br />table_name=$1",["text"])<br
/>clean=plpy.prepare("deletefrom dat_col where table_name=$1",["text"])<br
/>clean_tbl=plpy.execute(clean,[tbl_name])<br/>ins=plpy.prepare("insert into dat_col
values($1,$2,$3),["text","text","text"])<br/>data_rs=plpy.execute('select * from '+tbl_name)<br
/>cols_rs=plpy.execute(cols,[tbl_name])<br/>for i in range(len(data_rs)):<br /> for j in range(len(cols_rs)):<br />
plpy.execute(ins,(tbl_name,cols_rs[j]['column_name'],<br/> data_rs[i][cols_rs[j]['column_name'] ]))<br />$Body$<br
/>LANGUAGEplpythonu;<br /><br />For this to work I created a table dat_col(table_name text,column_name <br
/>text,column_datatext). The function deletes old data from the table before <br />it is run, based on table name. Just
runas dat_col_py("table name"). This <br />assumes you have pl/pythonu installed.<br />-- <br />Adrian Klaver <br
/>aklaver@comcast.net<br/><br />---------------------------(end of broadcast)---------------------------<br />TIP 9: In
versionsbelow 8.0, the planner will ignore your desire to<br /> choose an index scan if your joining column's datatypes
donot<br /> match<br /></blockquote><br /><p><hr size="1" />Cheap Talk? <a
href="http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com">Check
out</a>Yahoo! Messenger's low PC-to-Phone call rates.