Postgres Pro
Downloads
Home   >   mailing lists

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=v6efrmBQqHGdzqv7BkD9nhtESa9gLmSboe5DRpuXpX7w@mail.gmail.com
Whole thread Raw
In response to Re: xmltable in postgres like in oracle..?  (Ramesh T <rameshparnanditech@gmail.com>)
List pgsql-general
Tree view
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: xmltable in postgres like in oracle..?
Next
From: Adrian Klaver
Date:
Subject: Re: timestamp check