Re: LISTEN / NOTIFY enhancement request for Postgresql

Bruce Momjian <bruce(at)momjian(dot)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