Jan Wieck <[EMAIL PROTECTED]> writes: > I have a little patch that actually allows SPI_prepare() to > use UNKNOWN_OID in the passed in parameter type array and > put's the choosen datatypes Oid back into there.
> The parser treats those parameters like single quoted > literals of unknown type and chooses what would be the most > useful datatype here. > Any objections? For this particular application, at least, I do not see the value ... in fact this seems more likely to break stuff than help. If the application does not know what the datatypes are supposed to be, how is it going to call the prepared statement? You could possibly get away with that for a textual interface ("always pass quoted literals"), but it would surely destroy any chance of having a binary protocol for passing parameters to prepared statements. Offhand I'm having a hard time visualizing why you'd want this at the SPI_prepare level, either ... what's the application? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly