tag:blogger.com,1999:blog-35005627.post6155128559116136119..comments2023-09-01T13:15:10.510+03:00Comments on hype-free: Converting rows (records) to and from arrays in PostgresCd-MaNhttp://www.blogger.com/profile/05030326541176171725noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-35005627.post-9403127777670212072010-09-17T23:54:01.357+03:002010-09-17T23:54:01.357+03:00Sometimes you need directly from a table...
SELEC...Sometimes you need directly from a table...<br /><br />SELECT t.id, t.data1, t.data2, t.data3, t.data_in_array[t_idx.idx]<br /> FROM table1 as t, <br /> (SELECT id, generate_series(1,array_upper(data_in_array, 1)) as idx FROM table1) as t_idx<br />WHERE t.id = t_idx.idSposmenhttps://www.blogger.com/profile/05778357422595501038noreply@blogger.comtag:blogger.com,1999:blog-35005627.post-78117601962059701172010-07-27T13:50:31.460+03:002010-07-27T13:50:31.460+03:00Hi All, their is quite modification in above comma...Hi All, their is quite modification in above command,<br />select array(select id from table) into arrayname;Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-35005627.post-8593305035500053162010-05-17T11:53:13.069+03:002010-05-17T11:53:13.069+03:00This is helpful to me:
select array(select id fro...This is helpful to me:<br /><br /><b>select array(select id from table)</b><br /><br />Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-35005627.post-87045619746337028872009-07-26T18:49:58.352+03:002009-07-26T18:49:58.352+03:00thanks. very helpfulthanks. very helpfulAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-35005627.post-64040643842339359302008-12-11T15:56:00.000+02:002008-12-11T15:56:00.000+02:00thanks from Brasil.this helped me a lot very much....thanks from Brasil.<BR/>this helped me a lot very much.Anonymousnoreply@blogger.com