Re: Plpgsql function syntax error at first coalesce statement

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Ross <jross(at)wykids(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Plpgsql function syntax error at first coalesce statement
Date: 2010-04-25 20:20:27
Message-ID: 8542.1272226827@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Ross <jross(at)wykids(dot)org> writes:
> Now I'm *really* confused. I thought the table structure I created at
> the beginning of the function was where the results would be returned
> to.

Uh, you're using that as the destination for the FOR loop's SELECT.
What exactly is the purpose of having a second SELECT within the loop?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Ross 2010-04-25 21:07:32 Re: Plpgsql function syntax error at first coalesce statement
Previous Message Raymond O'Donnell 2010-04-25 20:09:39 Re: Plpgsql function syntax error at first coalesce statement