Re: xmltable in postgres like in oracle..?

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