Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Stephen Davies
On 20/02/16 16:21, Chris Travers wrote: A more general way would be to have a function which takes a pdf in and returns the text. Mark it immutable. Then you can index the output of converting that text to a tsvector. You may want to pull everything into a tsvector column for ease of review,

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Chris Travers
A more general way would be to have a function which takes a pdf in and returns the text. Mark it immutable. Then you can index the output of converting that text to a tsvector. You may want to pull everything into a tsvector column for ease of review, but functional indexes also make that less

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Stephen Davies
On 20/02/16 00:24, Bruce Momjian wrote: On Fri, Feb 19, 2016 at 02:49:16PM +0100, s d wrote: On 19 February 2016 at 14:19, Bruce Momjian wrote: > Ah, no. That's not possible > > > ...not possible, Yet. > > PostgreSQL grows by adding the

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Oleg Bartunov
On Fri, Feb 19, 2016 at 8:28 PM, Josh berkus wrote: > On 02/19/2016 05:49 AM, s d wrote: > >> On 19 February 2016 at 14:19, Bruce Momjian > > wrote: >> >> I wonder if PLPerl could be used to extract the words from a PDF >>

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Josh berkus
On 02/19/2016 05:49 AM, s d wrote: On 19 February 2016 at 14:19, Bruce Momjian > wrote: I wonder if PLPerl could be used to extract the words from a PDF document and create a tsvector column from it. I don't know about PLPerl(I'm pretty

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Daniel Westermann
>> >> I don't know about PLPerl(I'm pretty sure it could be used for this purpose, >> though.). On the other hand I've written code for this in Python which >> should >> be easy to adapt for PLPython, if necessary. >Right, so you would write a PL/Perl or PL/Python trigger function that

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Bruce Momjian
On Fri, Feb 19, 2016 at 02:49:16PM +0100, s d wrote: > On 19 February 2016 at 14:19, Bruce Momjian wrote: > >     Ah, no. That's not possible > > > > > > ...not possible, Yet. > > > > PostgreSQL grows by adding the features people need and its changing >

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread s d
On 19 February 2016 at 14:19, Bruce Momjian wrote: > On Fri, Feb 19, 2016 at 11:53:26AM +, Simon Riggs wrote: > > On 19 February 2016 at 11:46, Thomas Kellerer > wrote: > > > > Daniel Westermann schrieb am 19.02.2016 um 12:41: > > if I'd

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Bruce Momjian
On Fri, Feb 19, 2016 at 11:53:26AM +, Simon Riggs wrote: > On 19 February 2016 at 11:46, Thomas Kellerer wrote: > > Daniel Westermann schrieb am 19.02.2016 um 12:41: > if I'd need to implement/replace Oracle Text (ww.oracle.com/ >

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Simon Riggs
On 19 February 2016 at 11:46, Thomas Kellerer wrote: > Daniel Westermann schrieb am 19.02.2016 um 12:41: > if I'd need to implement/replace Oracle Text ( > ww.oracle.com/technetwork/testcontent/index-098492.html). > > What choices do I have in PostgreSQL (9.5+) ? > >

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Andreas Joseph Krogh
På fredag 19. februar 2016 kl. 12:41:49, skrev Daniel Westermann < daniel.westerm...@dbi-services.com >: >>Daniel Westermann schrieb am 19.02.2016 um 11:53: >>> if I'd need to implement/replace Oracle Text

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Thomas Kellerer
Daniel Westermann schrieb am 19.02.2016 um 12:41: if I'd need to implement/replace Oracle Text (ww.oracle.com/technetwork/testcontent/index-098492.html). > What choices do I have in PostgreSQL (9.5+) ? > >>Postgres also has a full text search (which I find much easier to use than

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Daniel Westermann
>>Daniel Westermann schrieb am 19.02.2016 um 11:53: >>> if I'd need to implement/replace Oracle Text >>> (ww.oracle.com/technetwork/testcontent/index-098492.html). What choices do I have in PostgreSQL (9.5+) ? >Postgres also has a full text search (which I find much easier to use than

Re: [GENERAL] Replacement for Oracle Text

2016-02-19 Thread Thomas Kellerer
Daniel Westermann schrieb am 19.02.2016 um 11:53: > if I'd need to implement/replace Oracle Text > (ww.oracle.com/technetwork/testcontent/index-098492.html). > What choices do I have in PostgreSQL (9.5+) ? Postgres also has a full text search (which I find much easier to use than Oracle's):

[GENERAL] Replacement for Oracle Text

2016-02-19 Thread Daniel Westermann
Hi, if I'd need to implement/replace Oracle Text (ww.oracle.com/technetwork/testcontent/index-098492.html). What choices do I have in PostgreSQL (9.5+) ? Regards Daniel