Re: xmltable in postgres like in oracle..? - Mailing list pgsql-general

From Ramesh T
Subject Re: xmltable in postgres like in oracle..?
Date
Msg-id CAK8Zd=sbPxh8Pm2B_s0jvR5hAOoA=0b_TCgjCh7_D-Jk_j2qcA@mail.gmail.com
Whole thread Raw
In response to xmltable in postgres like in oracle..?  (Ramesh T <rameshparnanditech@gmail.com>)
List pgsql-general
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@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 <rameshparnanditech@gmail.com> wrote:
xml table is the oracle function ..thank you sir

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



pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: Re: timestamp check
Next
From: Ramesh T
Date:
Subject: Re: xmltable in postgres like in oracle..?