Re: Plpgsql function syntax error at first coalesce statement

From: Jeff Ross <jross(at)wykids(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Plpgsql function syntax error at first coalesce statement
Date: 2010-04-25 21:07:32
Message-ID: 4BD4AF2C.2070403@wykids.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/25/10 14:20, Tom Lane wrote:
> 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
>
I am only an egg.

How else do I get the results I want--name, address, city, state, and so
on through the list out to whatever calls this function?

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Megha 2010-04-25 22:25:48 Help with pgpool-dbt2 database
Previous Message Tom Lane 2010-04-25 20:20:27 Re: Plpgsql function syntax error at first coalesce statement