ING FOR numword WITH my_synonym_dictionary, simple;
The dictionary must already have been created with CREATE TEXT SEARCH
DICTIONARY
Rich
On Sun, Nov 27, 2011 at 9:57 AM, Richard Greenwood
wrote:
> Oleg,
>
> Thank you. I am sure that you have identified my problem.
>
> \dF+ english (output
Sun, Nov 27, 2011 at 7:29 AM, Oleg Bartunov wrote:
> Richard,
>
> you should check your mapping - '1st' belongs to 'numword' and may be
> processed
> in a different way than 'first' or '1'.
>
> Oleg
> On Sat, 26 Nov 2011, Richard Greenwood w
403 <- this is what I want
SELECT count(*) FROM parcel_attrib WHERE txtsrch @@ to_tsquery('first');
count
---
403 <- this is also good
SELECT count(*) FROM parcel_attrib WHERE txtsrch @@ to_tsquery('1st');
count
---
4 <- this is not good. There a
('7695&south&Highway&89')
Any pointers as to what I am doing wrong would be greatly appreciated.
Regards,
--
Richard Greenwood
richard.greenw...@gmail.com
www.greenwoodmap.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Mar 5, 2009 at 12:29 PM, Steve Atkins wrote:
>
> On Mar 5, 2009, at 11:17 AM, Richard Greenwood wrote:
>
>> Hello pgsql listers,
>>
>> I've got a problem that is similar to, but I don't think identical to,
>> a cross tab query. My data looks l
ues. They only way I can see to do
>> it is programatically with a for loop. But before I do that I wanted
>> to bounce it off the fine minds that inhabit this list.
>>
>> Thanks,
>> Rich
>>
>> --
>> Richard Greenwood
>> richard.greenw...@gmail.com
habit this list.
Thanks,
Rich
--
Richard Greenwood
richard.greenw...@gmail.com
www.greenwoodmap.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the value. i.e. put both R1234 and
R0001234 into the tsvector column. This seems pretty brute force, and
I am pretty new to text search, so I'd welcome any suggestions.
Thanks,
Rich
--
Richard Greenwood
[EMAIL PROTECTED]
www.greenwoodmap.com
---(end of broa
On 5/16/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
Richard Greenwood wrote:
> I am getting an error from to_number() in PostgreSQL 8.2 that does not
> occur in 8.1:
> invalid input syntax for type numeric: " "
> I assume that it is rejecting spaces, so I tried
e same error.
Any suggestions?
Thanks,
Rich
--
Richard Greenwood
[EMAIL PROTECTED]
www.greenwoodmap.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
10 matches
Mail list logo
