Re: [SQL] Can't find which return type is incorrect.

2006-08-11 Thread Chris Lukenbill
Let me try this againMy first one got delayed when my gmail defualted to the wrong account.  (the response is inside codeWarrior's message.Thanks,ChrisOn 8/11/06, Chris Lukenbill <[EMAIL PROTECTED]> wrote: On 8/11/06, codeWarrior < [EMAIL PROTECTED]> wrote: Can you sho

[SQL] Can't find which return type is incorrect.

2006-08-11 Thread Chris Lukenbill
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 executed the error "wrong record type supplied in RETURN NEX

Re: [SQL] return setof records

2006-07-28 Thread Chris Lukenbill
: On Thu, Jul 27, 2006 at 03:41:31PM -0500, Chris Lukenbill wrote:> Everywhere I've looked the agreement was that making a call to the> function had to be done as follows:>> SELECT * FROM sp_frontalerts_summary(1,'2006-07-27 18:08:09','2006-07-27 > 19:58:15' ) as

[SQL] return setof records

2006-07-27 Thread Chris Lukenbill
Alright, first I'll apologize for asking this question another time. I've looked throught the archives and have found different ways on both the archives and different ways in the the documentation to do this and depending on which way I do it, I get different errors, so pick your poison on that.