Re: LISTEN / NOTIFY enhancement request for Postgresql - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: LISTEN / NOTIFY enhancement request for Postgresql
Date
Msg-id m2k3ga7lns.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: LISTEN / NOTIFY enhancement request for Postgresql  (Bruce Momjian <bruce@momjian.us>)
Responses Re: LISTEN / NOTIFY enhancement request for Postgresql  (Pavel Golub <pavel@microolap.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: GIN improvements part2: fast scan
Next
From: Tom Lane
Date:
Subject: Re: Transaction-lifespan memory leak with plpgsql DO blocks