syntax error at or near "START" in Postgres despite the fact that EXTENSION tablefunc is created

Asked Jun 16 '20 at 16:57

Active Jun 16 '20 at 18:20

Viewed 503 times

I have a query like this(which works in Oracle properly):

...
            LEFT JOIN myTable ON ....
            START WITH orgNodeId IN (
                SELECT someColumn FROM anothertable 
                WHERE ...

            )
        CONNECT BY PRIOR .. = ....
        )
        ...

but in posgres it doesn't work and I see error:

ERROR: syntax error at or near "START"
  Position: 282

Looks like my postgres doesn't now such syntax.

Based on https://stackoverflow.com/a/17935842/2674303 I ran:

CREATE EXTENSION tablefunc;

But it disn't help.

What could ve wrong ?

postgres version is 11.6

How to fix it ?

edited Jun 16 '20 at 18:20

asked Jun 16 '20 at 16:57

gstackoverflow

36,709
117
359
710

You can't just take Oracle code and run it in Postgres. You would need to provide sample data, desired results, and you actual query (not just part of it) so one can help rewriting it in Postgres. – GMB Jun 16 '20 at 16:59
@ GMB I read https://stackoverflow.com/a/37846191/2674303 - so not -it doesn't answer – gstackoverflow Jun 16 '20 at 17:00
@GMB I need unified query which works in both – gstackoverflow Jun 16 '20 at 17:31
@GMB In the linked post written that connect by could be enabled by executing CREATE EXTENSION tablefunc what did I wrong? – gstackoverflow Jun 16 '20 at 17:50
Linked post is https://stackoverflow.com/a/17935842/2674303 – gstackoverflow Jun 16 '20 at 17:51

syntax error at or near "START" in Postgres despite the fact that EXTENSION tablefunc is created

0 Answers0