Обсуждение: Postgres Array Traversing
Hallo All Frnds,
I have to add an array in my table. and to update the array in a Procedure called by the trigger.
In my case Like the Elements of the array are {1,2,5} now i have to update it to {1,2,5,7} . I.e., Keeping the previous record as such and appending the new elements.
Please reply at the urgent basis..............
Thanks in Advance......
you can reply me also at yogesh.arora@daffodildb.com
--
Best Regards,
Yogesh Arora
Mobile: 09255123173
Web : www.daffodildb.com
I have to add an array in my table. and to update the array in a Procedure called by the trigger.
In my case Like the Elements of the array are {1,2,5} now i have to update it to {1,2,5,7} . I.e., Keeping the previous record as such and appending the new elements.
Please reply at the urgent basis..............
Thanks in Advance......
you can reply me also at yogesh.arora@daffodildb.com
--
Best Regards,
Yogesh Arora
Mobile: 09255123173
Web : www.daffodildb.com
Yogesh Arora написа: > Hallo All Frnds, > > I have to add an array in my table. and to update the array in a > Procedure called by the trigger. > > In my case Like the Elements of the array are {1,2,5} now i have to > update it to {1,2,5,7} . I.e., Keeping the previous record as such and > appending the new elements. [...] According to the manual (http://www.postgresql.org/docs/current/static/arrays.html#AEN5830) this should work: UPDATE example_table SET an_array_column = an_array_column || 7 WHERE a_key_column = <value>; P.S. This questions is probably more appropriate for the "pgsql-sql" list. -- Milen A. Radev
On Oct 3, 8:28 pm, mi...@radev.net ("Milen A. Radev") wrote: > Yogesh Arora :> Hallo All Frnds, > > > I have to add an array in my table. and to update the array in a > > Procedure called by the trigger. > > > In my case Like the Elements of the array are {1,2,5} now i have to > > update it to {1,2,5,7} . I.e., Keeping the previous record as such and > > appending the new elements. > > [...] > > According to the manual > (http://www.postgresql.org/docs/current/static/arrays.html#AEN5830) this > should work: > > UPDATE example_table SET an_array_column = an_array_column || 7 WHERE > a_key_column = <value>; > > P.S. This questions is probably more appropriate for the "pgsql-sql" list. > > -- > Milen A. Radev > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate Thanks Milen A. Radev It Works..