; intended recipient, please contact the sender by reply email and destroy
> all copies of the original message. Check all attachments for viruses
> before opening them. All views or opinions presented in this e-mail are
> those of the author and may not reflect the opinion of Cyient or those of
> our affiliates.
>
--
[image: Nuxeo]
Florent Guillaume
Head of R&D
Twitter: @efge
age. Check all attachments for viruses
> before opening them. All views or opinions presented in this e-mail are
> those of the author and may not reflect the opinion of Cyient or those of
> our affiliates.
>
--
[image: Nuxeo]
Florent Guillaume
Head of R&D
Twitter: @efge
patibility with your app or migration:
>> >
>> >CREATE OR REPLACE FUNCTION tablename_setnull_trf()
>> > RETURNS trigger AS
>> >$BODY$
>> >BEGIN
>> >-- for all *string* columns
>> > NEW.colname1 = NULLIF (colname1,'');
>>
in particular handles pretty
>> well joins on text indexes.
>>
>> Did I understand correctly?
>>
>> Thanks,
>>
>> Anne
>>
>>
>
> --
> Sent from my Android phone with K-9 Mail. Please excuse my brevity.
--
Florent Guillaume, Director of R&D, N
On Wed, Nov 7, 2012 at 5:00 PM, Ivan Voras wrote:
> On 07/11/2012 16:54, Florent Guillaume wrote:
>> Maybe you could store the tags as fulltext words, query them using
>> fulltext search, and use ts_stat to gather the list of words? Needs to
>> be benched of course.
>&
ething that can be done to avoid creating another table or
> two. The reason I'm asking is that I've often found that PostgreSQL can
> do much more than I thought it can.
>
>
>
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Conten
(query1 @@ nx_to_tsvector(fulltext.fulltext)) OR (query2 @@
nx_to_tsvector(fulltext.fulltext_title))
ORDER BY nxscore DESC;
(as is also described in the doc mentioned btw).
Florent
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source, Java EE based, Enterprise Content Management (EC
