Re: xmltable in postgres like in oracle..?

[Ramesh T <rameshparnanditech@xxxxxxxxx>]

i got function 

select regexp_split_to_table('2,1', E',')::bigint

thanks

On Mon, Jul 13, 2015 at 4:13 PM, Ramesh T <rameshparnanditech@xxxxxxxxx> 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 <rameshparnanditech@xxxxxxxxx> wrote:

xml table is the oracle function ..thank you sir

On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx