> > In Oracle i use the command "connect by prior" and i need to use it in
> > PostgreSQL, what is the sintax?
>
> I was unable to find pg-hier in a quick cruise through PgFoundry.
Try http://gppl.moonbone.ru/
The patch is not yet fixed to 8.2.0. 8.1.2 looks to be the latest.
Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?
The last time I saw this discussed, Tom Lane referred to a "pg-hier"
modification but said this: "Beware that it makes an
incompatible change in rule r
Take a look at contrib/tablefunc there is a function called connectby()
that should do what you're looking for.
Otherwise roll your own...
http://archives.postgresql.org/pgsql-sql/2003-10/msg00374.php
John
Thomas Kellerer wrote:
On 08.01.2007 17:24 Scott Marlowe wrote:
On Mon, 2007-01-08 at
On 08.01.2007 17:24 Scott Marlowe wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?
What does connect by prior do? Reuse a connection from one db to
another? I don
It is used for Hierarchical queries in Oracle :)
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
> Hello everybody,
> In Oracle i use the command "connect by prior" and i nee
On Mon, 2007-01-08 at 07:38, Leandro Repolho wrote:
> Hello everybody,
> In Oracle i use the command "connect by prior" and i need to use it in
> PostgreSQL, what is the sintax?
What does connect by prior do? Reuse a connection from one db to
another? I don't think there's anything like that in
There is no default support but you can always use connectby() function from
the tablefunc contrib module
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 1/8/07, Leandro Repolho <[EMAIL PROTECTED]> wrote:
Hello everybody,
In Oracle i use the command "connect by prior" and
Hello everybody,
In Oracle i use the command "connect by prior" and i need to use it in
PostgreSQL, what is the sintax?