agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: Karen Goh <karenworld@yahoo.com>
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
Date: Sun, 14 Jul 2019 09:10:01 +0100
Message-ID: <87pnmdniry.fsf@news-spur.riddles.org.uk> (raw)
In-Reply-To: <1846547624.530883.1563075598322@mail.yahoo.com>
References: <110414461.528890.1563075361778@mail.yahoo.com>
	<1846547624.530883.1563075598322@mail.yahoo.com>

>>>>> "Karen" == Karen Goh <karenworld@yahoo.com> writes:

 Karen> This is a continuation of my last problem - not sure if I should
 Karen> write from there cos the first part was solved with the help
 Karen> from this group.

 Karen> I was trying to get the matching tutor_id with the parameter
 Karen> values which is in this case subject_names from a table which
 Karen> contains both the tutor_id and the subject_names.

 Karen> Here's the error message:

When you post these questions, you really need to include the ACTUAL SQL
TEXT of the query, not just the code snippet that constructs the query
(because that way we can't see for sure what query actually got
constructed). The best place to find that is in the postgresql server's
own logs.

I would guess that the problem is that you're passing an integer
parameter where you ought to be passing a string.

-- 
Andrew (irc:RhodiumToad)

view thread (24+ messages)  latest in thread

Message-ID: <87pnmdniry.fsf@news-spur.riddles.org.uk>
Permalink:  ../87pnmdniry.fsf@news-spur.riddles.org.uk/
Also on:    postgresql.org/message-id/87pnmdniry.fsf@news-spur.riddles.org.uk

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-sql@postgresql.org
  Cc: andrew@tao11.riddles.org.uk, karenworld@yahoo.com, pgsql-sql@lists.postgresql.org
  Subject: Re: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer?
  In-Reply-To: <87pnmdniry.fsf@news-spur.riddles.org.uk>

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

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