Search Postgresql Archives
Re: SQL Question about like
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: SQL Question about like
From
: Michael Nolan <htfoot@xxxxxxxxx>
Date
: Mon, 10 Aug 2020 12:01:08 -0500
Cc
: "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
00d20cc2-0c97-8ce7-768a-a2c8bc396d19@gmx.de
>
References
: <
00d20cc2-0c97-8ce7-768a-a2c8bc396d19@gmx.de
>
The problem is your field is fixed length text, change it to varchar(100) or text and it works without the wildcard at the end.
--
Mike Nolan
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: SQL Question about like
From:
Adrian Klaver
References
:
SQL Question about like
From:
pgml@xxxxxx
Prev by Date:
Re: UUID or auto-increment
Next by Date:
Re: UUID or auto-increment
Previous by thread:
Re: SQL Question about like
Next by thread:
Re: SQL Question about like
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]