pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Erik Wienhold <ewie@ewie.name>
To: M Sarwar <sarwarmd02@outlook.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS
Date: Wed, 5 Jul 2023 23:46:26 +0200 (CEST)
Message-ID: <1358455621.855150.1688593586940@office.mailbox.org> (raw)
In-Reply-To: <DM4PR19MB5978DBFB23F2A12E591D3A40D32FA@DM4PR19MB5978.namprd19.prod.outlook.com>
References: <PH2P110MB0922161A06BF0F0AF502C420FF2FA@PH2P110MB0922.NAMP110.PROD.OUTLOOK.COM>
	<DM4PR19MB59789AC5B76EA5829DF176E9D32FA@DM4PR19MB5978.namprd19.prod.outlook.com>
	<DM4PR19MB597845608FD03283CC6EEB1DD32FA@DM4PR19MB5978.namprd19.prod.outlook.com>
	<1539000886.854641.1688592359041@office.mailbox.org>
	<DM4PR19MB5978DBFB23F2A12E591D3A40D32FA@DM4PR19MB5978.namprd19.prod.outlook.com>

> On 05/07/2023 23:34 CEST M Sarwar <sarwarmd02@outlook.com> wrote:
>
> Table has no indexes so far.

Do you get the same results when using LIKE instead?

	SELECT test_number
	FROM bronx.test_test_details_all_mcm
	WHERE test_description LIKE ' %'

--
Erik





view thread (8+ messages)  latest in thread

Message-ID: <1358455621.855150.1688593586940@office.mailbox.org>
Permalink:  ../1358455621.855150.1688593586940@office.mailbox.org/
Also on:    postgresql.org/message-id/1358455621.855150.1688593586940@office.mailbox.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ewie@ewie.name, sarwarmd02@outlook.com, pgsql-admin@lists.postgresql.org
  Subject: Re: SQL is fetching results BLANK checks but the data has no BLANKS
  In-Reply-To: <1358455621.855150.1688593586940@office.mailbox.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox