Could you please post the exact string how you did?
Thanks
Deepak
On Thu, Apr 29, 2010 at 12:59 AM, Edward Ross wrote:
> Tom Lane wrote:
>
>> Edward Ross writes:
>>
>>> Here is a sandbox example of what I mean.
>>>
>>
>> CREATE TABLE test_0
>>> (
>>>string_value varchar(2047),
>>>time
On Thu, 29 Apr 2010 19:27:33 +0530 wrote
>On Thu, Apr 29, 2010 at 01:13:40PM -, sandeep prakash dhumale wrote:
>> Hello All,
>>
>> I am trying to get tsearch working for my application but I am facing a
>> problem when alphabet 'Y' is the in the tsquery.
>>
>> can anyone please share some
"sandeep prakash dhumale" writes:
> I am trying to get tsearch working for my application but I am facing a
> problem when alphabet 'Y' is the in the tsquery.
> # SELECT 'hollywood'::tsvector @@ to_tsquery('holly:*');
> ?column?
> --
> f
> (1 row)
You can't use to_tsquery for this sor
Hello All,
I am trying to get tsearch working for my application but I am facing a
problem when alphabet 'Y' is the in the tsquery.
can anyone please share some light on it.
# SELECT 'hollywood'::tsvector @@ to_tsquery('holly:*');
?column?
--
f
(1 row)
SELECT 'hollywood'::tsvector
On 4/28/2010 10:34 PM, Andreas wrote:
> Hi,
>
> while writing the reply below I found it sounds like beeing OT but
> it's actually not.
> I just need a way to check if a collumn contains values that CAN NOT
> be converted from Utf8 to Latin1.
> I tried:
> Select convert_to (my_column::text, 'LATI
Tom Lane wrote:
Edward Ross writes:
Here is a sandbox example of what I mean.
CREATE TABLE test_0
(
string_value varchar(2047),
timestamp_value timestamp with time zone
);
insert into test_0
(string_value)
values
('2010-03-12 17:06:21-0800'),
('2009-08-14
