Postgres Pro
Downloads
Home   >   mailing lists

Re: Plpgsql function syntax error at first coalesce statement - Mailing list pgsql-general

From Tom Lane
Subject Re: Plpgsql function syntax error at first coalesce statement
Date
Msg-id 8542.1272226827@sss.pgh.pa.us
Whole thread Raw
In response to Re: Plpgsql function syntax error at first coalesce statement  (Jeff Ross <jross@wykids.org>)
Responses Re: Plpgsql function syntax error at first coalesce statement  (Jeff Ross <jross@wykids.org>)
List pgsql-general
Tree view 
Jeff Ross <jross@wykids.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

pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Plpgsql function syntax error at first coalesce statement
Next
From: Jeff Ross
Date:
Subject: Re: Plpgsql function syntax error at first coalesce statement