Re: Varying Character comparison

2021-01-06 Thread Jack Royal-Gordon
70 N. Grove Ave. > Elgin, IL 60120 > Phone: (847) 429-5986 Fax: (847) 608-5201 > http://www.gailborden.info <http://www.gailborden.info/> > > From: richard coleman > Sent: Wednesday, January 6, 2021 12:42 PM > To: Joseph Ruffino > Cc: pgadmin-support@lists.postgresql.o

Re: Varying Character comparison

2021-01-06 Thread Rob Richardson
-5986 Fax: (847) 608-5201 http://www.gailborden.info   From: richard coleman Sent: Wednesday, January 6, 2021 12:42 PM To: Joseph Ruffino Cc: pgadmin-support@lists.postgresql.org Subject: Re: Varying Character comparison   Joseph,    This is really an SQL question, not something

RE: Varying Character comparison

2021-01-06 Thread Joseph Ruffino
Character comparison Joseph, This is really an SQL question, not something specific to PostgreSQL or pgAdmin. That being said, it looks like your e.index_entry field is of type varchar (character varying) and you are trying to compare it to an int. If that is the case you will need to either cast

Re: Varying Character comparison

2021-01-06 Thread richard coleman
Joseph, This is really an SQL question, not something specific to PostgreSQL or pgAdmin. That being said, it looks like your e.index_entry field is of type varchar (character varying) and you are trying to compare it to an int. If that is the case you will need to either cast the e.index_entry f

Varying Character comparison

2021-01-06 Thread Joseph Ruffino
Hi, I am not sure if this is how I add a question, but I cannot find anything on lists.postgesql.org. I am having a problem with a SQL that I am running in pgAdmin 4.27. The SQL is being used to check for duplicates in our PostgreSQL DB. I am trying to edit out the barcode (e.index_entry) whe