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
Borden Public Library District Web Programmer 270 N. Grove Ave. Elgin, IL 60120 Phone: (847) 429-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

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