U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » PostgreSql does not handle BOOL correctly

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: PostgreSql does not handle BOOL correctly [message #60061 is a reply to message #59950]

Thu, 27 July 2023 16:09

omari is currently offline

omari
Messages: 276
Registered: March 2010

Experienced Member

In order to provide a test case, i have modified PostgreSql referance example by adding a bool field:

TABLE_(TESTPARTNER)
   SERIAL_  (TESTPARTNER_ID) PRIMARY_KEY
   STRING_  (TESTPARTNER_NAME, 200) INDEX
   STRING_  (TESTPARTNER_ADDRESS, 200)
   BOOL_    (IS_OK)                   <---------- field added
END_TABLE

and i have added a Where condition to the Query:

	m_array.Query(IS_OK == true);

the result is: at runtime, it show this ERROR messages :

The operation has failed

SQL error:
ERREUR: l'opérateur n'existe pas : character = integer
LINE 1: ...RTNER_ADDRESS, IS_OK from TESTPARTNER where IS_OK = 1 order ...
^
HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.

Error statement:
select TESTPARTNER_ID, TESTPARTNER_NAME, TESTPARTNER_ADDRESS, IS_OK from TESTPARTNER where IS_OK = 1 order by TESTPARTNER_NAME

Attachment: SQL_PostgreSql.7z
(Size: 1.62KB, Downloaded 103 times)

regards
omari.

Report message to a moderator

Send a private message to this user

[Message index]

		PostgreSql does not handle BOOL correctly By: omari on Sun, 11 June 2023 17:12
		Re: PostgreSql does not handle BOOL correctly By: omari on Thu, 27 July 2023 16:09
		Re: PostgreSql does not handle BOOL correctly By: omari on Thu, 27 July 2023 16:15
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: omari on Wed, 04 October 2023 18:50
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: mirek on Fri, 20 October 2023 09:41
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: mirek on Fri, 20 October 2023 09:52
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: omari on Sat, 21 October 2023 00:33
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: omari on Sat, 21 October 2023 01:14
		Re: PostgreSql does not handle BOOL correctly [BUG+PATCH] By: mirek on Sat, 21 October 2023 17:22

Previous Topic:	SqlPerformScript bug: Not doing anything if script starts with "BEGIN;" and ends with "END;"
Next Topic:	Sqlite3 update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Wed Jun 04 00:37:18 CEST 2025

Total time taken to generate the page: 0.10728 seconds