Can't find which return type is incorrect.
От | Chris Lukenbill |
---|---|
Тема | Can't find which return type is incorrect. |
Дата | |
Msg-id | fdb4b04c0608110745t6dea55aeod40cf8e19a283dc1@mail.gmail.com обсуждение исходный текст |
Список | pgsql-sql |
Alright. I have a very large amount of columns being returned by this stored procedure that I ported from MS SQL to Postgres. Now the problem I'm having is that when the select * from sp_whatever(1,0,3) as ( foo int, bar int, etc.) is executedthe error "wrong record type supplied in RETURN NEXT CONTEXT". Now this immediately red flagged me to look at thetypes that I was returning and verify that those were the types that I was catching in the as statement. I went throughto verify all of the variables and they are all correct as far as both name and the exact type. Therefore there areonly a few things left that I'm thinking could be the problem. <br /><br />1. Too many variables returned (there are 44variables being returned).<br />2. Some of the variables that are smallint in the select statement also do a if isnulltype of logic that will return zero if they are null. (is that zero not coming back as a smallint then?) <br />3.What I'm declaring as a variable type in postgresql isn't the variable type in PHP. The following are the differenttypes of variables that I use:<br />INT<br />SMALLINT<br />BIGINT (when I do a count(*))<br />VARCHAR(xx) <br />TEXT<br/>TIMESTAMP<br />NUMERIC(19,2)<br /><br /><br />Now the two there that I'm skeptical about are the timestamp andthe numeric.<br /><br />Thanks ahead of time for any ideas,<br />Chris<br /><br />
В списке pgsql-sql по дате отправления: