Search Postgresql Archives

Re: xmltable in postgres like in oracle..?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux