Skip site navigation (1) Skip section navigation (2)

Re: BUG #3951: SELECT ... WHERE Param = ? does not work if Param is of type bytea

From: "Gevik Babakhani" <pgdev(at)xs4all(dot)nl>
To: "'vha'" <vincent_dhaene(at)hotmail(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3951: SELECT ... WHERE Param = ? does not work if Param is of type bytea
Date: 2008-02-10 22:09:16
Message-ID: 000c01c86c31$93ce7e80$0a01a8c0@gevmus (view raw or flat)
Thread:
Lists: pgsql-bugs
perhaps this helps

http://www.webservertalk.com/archive308-2007-3-1836413.html
 

> -----Original Message-----
> From: pgsql-bugs-owner(at)postgresql(dot)org 
> [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of vha
> Sent: Sunday, February 10, 2008 7:55 PM
> To: pgsql-bugs(at)postgresql(dot)org
> Subject: [BUGS] BUG #3951: SELECT ... WHERE Param = ? does 
> not work if Param is of type bytea
> 
> 
> The following bug has been logged online:
> 
> Bug reference:      3951
> Logged by:          vha
> Email address:      vincent_dhaene(at)hotmail(dot)com
> PostgreSQL version: 8.3
> Operating system:   Windows XP SP2
> Description:        SELECT ... WHERE Param = ? does not work 
> if Param is of
> type bytea
> Details: 
> 
> I have a table with one of the columns of type BYTEA 
> containing GUIDs (16 bytes of data).
> 
> The data of the column is specified using 
> SQLBindParameter(hstmt, nCol, SQL_PARAM_INPUT, SQL_C_BINARY, 
> SQL_BINARY, 16, 0, theGUID, 16, &ptr).
> 
> This works fine to insert the data using "INSERT ... VALUES 
> ?", but retrieving the data using "SELECT ... WHERE Param = 
> ?" doesn't work: nothing is returned.
> 
> Am I doing something wrong or is this a bug?
> 
> BTW. This code works without any problem on MS SQL 2000, MS 
> SQL 2005, Oracle and MySQL.
> 
> 
> vha
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org 
> so that your
>        message can get through to the mailing list cleanly
> 


In response to

Responses

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2008-02-11 02:22:53
Subject: Re: BUG #3948: date/time functions returning wrong value
Previous:From: Tom LaneDate: 2008-02-10 20:18:35
Subject: Re: 8.3.0: vacuum full analyze: "invalid memory alloc request size"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group