On 10/4/06, Alexander Burbello <[EMAIL PROTECTED]> wrote:
Hi people,I need to know if Postgres do recursive search and how can I do!I will explain my problem.table COOPERATIVE code_cooperative int code_coo_father intI can have 3 level by business rules
1 - Father- 2 - Children- 3 - Gr
On Tue, Oct 10, 2006 at 04:33:46PM -0500, Jay A. Kreibich wrote:
> On Tue, Oct 10, 2006 at 10:15:42AM -0500, Jim C. Nasby scratched on the wall:
> > On Fri, Oct 06, 2006 at 10:37:26AM -0500, Jay A. Kreibich wrote:
> > > These are generally referred to as "Hierarchical Queries" and center
> > >
On Tue, Oct 10, 2006 at 10:15:42AM -0500, Jim C. Nasby scratched on the wall:
> On Fri, Oct 06, 2006 at 10:37:26AM -0500, Jay A. Kreibich wrote:
> > These are generally referred to as "Hierarchical Queries" and center
> > around the idea of a self-referencing table (such as an employee
> > ta
On Fri, Oct 06, 2006 at 10:37:26AM -0500, Jay A. Kreibich wrote:
> These are generally referred to as "Hierarchical Queries" and center
> around the idea of a self-referencing table (such as an employee
> table with a "manager" field that is a FK to another row in the same
> table). This e
[EMAIL PROTECTED] (Alexander Burbello) writes:
> Hi people,
>
> I need to know if Postgres do recursive search and how can I do!
> I will explain my problem.
>
>
> table COOPERATIVE
> code_cooperative int
> code_coo_father int
>
> I can have 3 level by business rules
>
> 1 - Father
> - 2 - Ch
On Wed, Oct 04, 2006 at 10:08:10AM -0300, Alexander Burbello scratched on the
wall:
> Hi people,
>
> I need to know if Postgres do recursive search and how can I do!
> I will explain my problem.
>
>
> table COOPERATIVE
> code_cooperative int
> code_coo_father int
>
> I can have 3 level by bu
I think it is not administration thing, but SQL language problem.
PostgreSQL is SQL92 compatible and has many very good and useful addons.
Generally, PostgreSQL gives You tools to analyze all, what You want,
when You hava data in tables.
You've explained in to short way You problem. The best is
On Wed, Oct 04, 2006 at 10:08:10 -0300,
Alexander Burbello <[EMAIL PROTECTED]> wrote:
>
> I need to know if Postgres do recursive search and how can I do!
There is a contrib module (tablefunc I think) that allows recursive queries.
However in your example below, you don't actuall need recursion
Hi people,
I need to know if Postgres do recursive search and how can I do!
I will explain my problem.
table COOPERATIVE
code_cooperative int
code_coo_father int
I can have 3 level by business rules
1 - Father
- 2 - Children
- 3 - Grandchildren
I would like to have a query ask
