Re: LISTEN / NOTIFY enhancement request for Postgresql

Hello, Dimitri.

You wrote:

DF> 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?

DF> I think we should consider the ltree syntax in that case, as documented
DF> in the following link:

DF> http://www.postgresql.org/docs/9.3/interactive/ltree.html

Great idea! Thanks for link.

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

--
With best wishes,
Pavel mailto:pavel(at)gf(dot)microolap(dot)com