Hi,
Finally I have found the problem: the table was corrupted, so i have
recreated it and it works fine.
I wonder if instead of recreating it i would have had to execute a vacuum.
Thanks to you all for your help and your suggestions (i will keep them for
the future).
Gabi :-)
Gabriel Fernandez wrote:
> Hi,
>
> I have some problems using LIKE within strings which have brackets.
>
> For example if i do:
>
> select code from codes where code like '(4)' ;
>
> i do not obtain nothing. But in the DB indeed there is a row whose code
> is '(4)'.
>
> I have tried to escape the
Gabriel Fernandez wrote:
>
> Hi,
>
> I have some problems using LIKE within strings which have brackets.
>
> For example if i do:
>
> select code from codes where code like '(4)' ;
>
> i do not obtain nothing. But in the DB indeed there is a row whose code
> is '(4)'.
>
> I have tried to esc
> (2 rows)
>
> business=> select * from foo where mytext like '(4)';
> mytext
> --
> (0 rows)
>
> business=> select * from foo where mytext like '(4)%';
> mytext
> --
> (4)
> (1 row)
>
> Phil Culberson
> DAT Services
mytext
--
(0 rows)
business=> select * from foo where mytext like '(4)%';
mytext
--
(4)
(1 row)
Phil Culberson
DAT Services
-Original Message-
From: Gabriel Fernandez [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 21, 2000 4:47 AM
To: PostgreSQL-general
Subj
Hi,
I have some problems using LIKE within strings which have brackets.
For example if i do:
select code from codes where code like '(4)' ;
i do not obtain nothing. But in the DB indeed there is a row whose code
is '(4)'.
I have tried to escape the brackets with '\\(4\\)' or with ' \(4\)' but
