Re: How to remove elements from array .

2018-07-06 Thread Pavel Stehule
lt; >> clavadetsc...@swisspug.org>: >> >>> Hi >>> >>> >>> >>> *From:* Brahmam Eswar [mailto:brahmam1...@gmail.com] >>> *Sent:* Freitag, 6. Juli 2018 09:50 >>> *To:* pgsql-general ; >>> pgsql-hack...@postgresql.or

Re: How to remove elements from array .

2018-07-06 Thread Brahmam Eswar
e wrote: > Hi > > 2018-07-06 10:19 GMT+02:00 Charles Clavadetscher < > clavadetsc...@swisspug.org>: > >> Hi >> >> >> >> *From:* Brahmam Eswar [mailto:brahmam1...@gmail.com] >> *Sent:* Freitag, 6. Juli 2018 09:50 >> *To:* pgsql-gen

Re: How to remove elements from array .

2018-07-06 Thread Pavel Stehule
Hi 2018-07-06 10:19 GMT+02:00 Charles Clavadetscher : > Hi > > > > *From:* Brahmam Eswar [mailto:brahmam1...@gmail.com] > *Sent:* Freitag, 6. Juli 2018 09:50 > *To:* pgsql-general ; > pgsql-hack...@postgresql.org > *Subject:* How to remove elements from array . >

Re: How to remove elements from array .

2018-07-06 Thread Pavel Stehule
Hi 2018-07-06 9:49 GMT+02:00 Brahmam Eswar : > Hi , > > I tried to use array_remove to remove elements from an array but it's > saying function doesn't exist . I'm able to use other array functions. > > 1) Capture the results with multiple columns into array . > 2) if ay results exist then loop

RE: How to remove elements from array .

2018-07-06 Thread Charles Clavadetscher
Hi From: Brahmam Eswar [mailto:brahmam1...@gmail.com] Sent: Freitag, 6. Juli 2018 09:50 To: pgsql-general ; pgsql-hack...@postgresql.org Subject: How to remove elements from array . Hi , I tried to use array_remove to remove elements from an array but it's saying function do

How to remove elements from array .

2018-07-06 Thread Brahmam Eswar
Hi , I tried to use array_remove to remove elements from an array but it's saying function doesn't exist . I'm able to use other array functions. 1) Capture the results with multiple columns into array . 2) if ay results exist then loop through an array to find out the record with col1='Y' 3) I