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

BUG #5001: can not prepare for where $1 is null

From: "" <94487509(at)qq(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5001: can not prepare for where $1 is null
Date: 2009-08-21 08:41:18
Message-ID: 200908210841.n7L8fIQq083062@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      5001
Logged by:          
Email address:      94487509(at)qq(dot)com
PostgreSQL version: 8.3.3
Operating system:   linux
Description:        can not prepare for where $1 is null
Details: 

why can not prepare like this? thanks!
 prepare ssss as select * from test where $1 is null;
 ERROR:  could not determine data type of parameter $1

Responses

pgsql-bugs by date

Next:From: PramodDate: 2009-08-21 13:35:39
Subject: BUG #5003: setup error
Previous:From: Tom LaneDate: 2009-08-20 22:40:10
Subject: Re: BUG #4999: select 'a' < 'A' is true, but should be false . . .

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