Re: xmltable in postgres like in oracle..?

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(at)gmail(dot)com>
wrote:

> xml table is the oracle function ..thank you sir
>
> On Sat, Jul 11, 2015 at 11:04 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>>
>
>