Re: LISTEN / NOTIFY enhancement request for Postgresql

Bruce Momjian <bruce@momjian.us> writes:
>>   • is used to separate names in a path
>>   • * is used to match any name in a path
>>   • > is used to recursively match any destination starting from this name
>>
>> For example using the example above, these subscriptions are possible
>>
>>     Subscription                      Meaning
>> PRICE.>              Any price for any product on any exchange
>> PRICE.STOCK.>        Any price for a stock on any exchange
>> PRICE.STOCK.NASDAQ.* Any stock price on NASDAQ
>> PRICE.STOCK.*.IBM    Any IBM stock price on any exchange
>>
>>
>> My request is to implement the same or similar feature in Postgresql.
>
> This does seem useful and pretty easy to implement.  Should we add a
> TODO?

I think we should consider the ltree syntax in that case, as documented
in the following link:
 http://www.postgresql.org/docs/9.3/interactive/ltree.html

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support