Re: Like Command returning wrong result set

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Like Command returning wrong result set
Дата
Msg-id CAFj8pRD1BFY=kBQvVkwkssvzaEzYSYhiqxvU3Keesg=u8j-gvw@mail.gmail.com
обсуждение исходный текст
Ответ на Sv: Like Command returning wrong result set  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-sql


čt 5. 8. 2021 v 16:04 odesílatel Andreas Joseph Krogh <andreas@visena.com> napsal:
På torsdag 05. august 2021 kl. 16:00:38, skrev Tchouante, Merlin <mtchouan@umaryland.edu>:

Hello group,

 

I’m writing a script and a bit confused on the results with the like command.

 

gm.title like 'CP_%'

 

The above command gives me records with titles like CP_40, CP_2, CP_23, etc.

 

gm.title like '%_CT'

 

The above command give me records with tiles like Quiz: RadiInterpretation w/ CBCT.

 

I was expecting it to return titles that contained *_CT, i.e. FX_CT or DR_CT.  It’s as if it’s ignoring the underscore the way it would do if you were using ‘%CT’.  Does it ignore the underscore when it’s right after the ‘%’?

 
  • Percent sign ( %) matches any sequence of zero or more characters.
  • Underscore sign ( _)  matches any single character.

yes


Regards

Pavel

     
    --
    Andreas Joseph Krogh

    В списке pgsql-sql по дате отправления:

    Предыдущее
    От: Andreas Joseph Krogh
    Дата:
    Сообщение: Sv: Like Command returning wrong result set
    Следующее
    От: Christophe Pettus
    Дата:
    Сообщение: Re: Like Command returning wrong result set