In the pgsql tutorial two tables are created capitals inherits cities. When you do SELECT * FROM cities, you get both capitals and cities. Is there anyway to get get the name of the table so I could possibly know the 'type' it was? Or should this be maintained as a separate column 'city_type' that has a value of 'capital'? Suppose I had another table river_cities and what I would want to be able to is SELECT * FROM cities and know whether the city was a river_city, capital, or nothing at all. thanks, --eric ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
