xmltable in postgres like in oracle..?
Hi,
is xmltable available in postgres..?,if not please give me a advice
to replace the xmtable in postgres..?
Hi,
is xmltable available in postgres..?,if not please give me a
advice to replace the xmtable in postgres..?
Hi,
PostgreSQL has a native XML type and related functions:
http://www.postgresql.org/docs/9.4/static/datatype-xml.html
http://www.postgresql.org/docs/9.4/static/functions-xml.html
Bye,
Chris.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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:
Show quoted text
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
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:
Show quoted text
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
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:
Show quoted text
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 tablehow 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