On 03/01/2013 12:14 PM, bhanu udaya wrote:
>
> I need a query to retrieve all the n level hierarchy when a Child
> node_id is passed.
I think you're probably looking for the pgsql-general mailing list or
Stack Overflow. This list is focused on the PgAdmin-III program.
--
Craig Ringer
Greetings !
I have a hierarchy table with two attributes : Parent_ID, Child_ID with the
sample data (can go upto n-level) as below:
ParentID
ChildID
1
3
1
4
3
5
5
6
6
7
I need a query to retrieve all the n level hierarchy when a Child node_id
On Fri, 2013-03-01 at 08:19 +1000, Alex Proshutinsky wrote:
> 01.03.2013, 07:38, "Guillaume Lelarge" :
> >> 1. open properties of the role (group or login)
> >> 2. button "ok" - is active by default
> >> 3. press "ok" - role will be altered with "VALID UNTIL '1970-01-01
> >> 00:00:00';"
> >> 4
On Thu, 2013-02-28 at 11:54 +1000, Alex Proshutinsky wrote:
> 1. open properties of the role (group or login)
> 2. button "ok" - is active by default
> 3. press "ok" - role will be altered with "VALID UNTIL '1970-01-01 00:00:00';"
> 4. as a result of #.3 role blocked...
>
> this trouble exists on
