i got function select regexp_split_to_table('2,1', E',')::bigint thanks
On Mon, Jul 13, 2015 at 4:13 PM, Ramesh T <rameshparnandit...@gmail.com> wrote: > WITH idtable AS ( > SELECT '2342,8766' id > ) > > select * from inv where id in( > SELECT id > FROM idtable) > > But in query need seperate row by row > like 2342 > 8766 > using these idtable id i'm checking in inv table id, if same id then > return result from inv table > > how to seperate row by row from temp table....? > > On Sun, Jul 12, 2015 at 5:38 PM, Ramesh T <rameshparnandit...@gmail.com> > wrote: > >> xml table is the oracle function ..thank you sir >> >> On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver < >> adrian.kla...@aklaver.com> wrote: >> >>> On 07/11/2015 08:32 AM, Ramesh T wrote: >>> >>>> Hi, >>>> is xmltable available in postgres..?,if not please give me a >>>> advice to replace the xmtable in postgres..? >>>> >>> >>> What is xmltable? >>> >>> Go to: >>> >>> http://www.postgresql.org/docs/9.4/interactive/index.html >>> >>> and in the Search field type xml >>> >>> >>> -- >>> Adrian Klaver >>> adrian.kla...@aklaver.com >>> >> >> >