Re: Problem on function returning setof custom type

From: Pablo Baena <pbaena(at)gmail(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem on function returning setof custom type
Date: 2005-06-22 17:43:03
Message-ID: 36be2c7a0506221043260c867a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You are amazing! It solved it! Thanks!!

On 6/22/05, Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:
>
> On Wed, 22 Jun 2005, Pablo Baena wrote:
>
> > FOR rec IN SELECT test.id <http://test.id> <http://test.id>, test.blow,
> test1.bla2
> > FROM test
> > LEFT JOIN test1 ON test.id <http://test.id> <http://test.id> = test1.id<http://test1.id><
> http://test1.id>WHERE
> > test1.bla2=\'$1\' LOOP
>
> This is going to compare to the exact string '$1' not to the value of the
> argument since you've quoted it. I think you'd just want test1.bla2 = $1
> there.
>

--
> There are a lot of us out there who both do and do not work for Sun

Wow! Quantum programmers!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-06-22 17:47:57 Re: table and column information from cursor?
Previous Message Roberto Pellagatti 2005-06-22 16:50:40 plpgsql and schema