Ndtyjky

I have table, that called addressobject.

addressobject (

    aoid character varying(36),   //it is unique for table

    aoguid character varying(36), //it is not unique value. 

                                  //Has equal value for the same address objects

    parent_guid character varying(36), //link to parent aoguid

    currstatus integer // if this equal 0, then address object is actual.

                       //Only one addressobject's currstatus is equal to 0 in group of same aoguids

    name character varying(120) //I think it is clear

    aolevel //level in hierarchy

)

I need to find all rows, that contains passed text.
Example, for string 'regionname areaname cityname %notCompletedStreetName%' I need to return rows that contains similar text after concatenation name with his parent name and parents of all his parents before parent_guid is not null

UPD

OK There is example of table. I make aoid and aoguid like integer to simplify, by actually it has uuid presented to character varying(36):

aoid | aoguid  | parent_guid | currstatus | aolevel | name

1    | 100     |             | 0          | 1       |'Dagestan'

2    | 200     | 100         | 1          | 3       |'Makhachkala' //outdated row

3    | 200     | 100         | 0          | 3       |'Makhachkala'  

4    | 400     | 200         | 1          | 4       |'Gamidov' //outdated row

5    | 500     | 200         | 0          | 4       |'Gamburger' 

6    | 600     | 200         | 0          | 4       |'Burger'

7    | 400     | 200         | 0          | 4       |'Gamidov'

8    | 800     | 100         | 0          | 3       |'Derbent'  

If I have passed string like 'Dagestan Makhachkala Gam', where 'Gam' is beginning of the not completed street name, 'Makhachkala' and 'Dagestan' is completed name of city and region respectively, area name in this case not exist. In this case it should return rows with aoid 5 and 7.

Input 'Dagestan Makhachkala Gam', Rows: 5, 7

Input 'Dagestan Derbent', Rows: 8

Input 'Dagestan Makhach', Rows: 3

Input 'Dagestan Makhachkala Burg', Rows: 6

etc..

UPDEND

I hope I clearly explained the problem :

First you can create the hierarchy with

SELECT aoid

FROM addressobject region

LEFT JOIN addressobject area

ON

    region.aoguid = area.parent_guid

LEFT JOIN addressobject city

ON

    area.aoguid = city.parent_guid

LEFT JOIN addressobject street

ON

    city.aoguid = street.parent_guid

Next you have to search

WHERE

    region.name LIKE REGIONNAME

    AND (NOT area.aoguid OR area.name LIKE AREANAME

        AND (NOT city ...