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!
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 |