Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem on function returning setof custom type - Mailing list pgsql-general

From Pablo Baena
Subject Re: Problem on function returning setof custom type
Date
Msg-id 36be2c7a0506221043260c867a@mail.gmail.com
Whole thread Raw
In response to Re: Problem on function returning setof custom type  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Tree view
You are amazing! It solved it! Thanks!!

On 6/22/05, Stephan Szabo <sszabo@megazone.bigpanda.com> wrote:
On Wed, 22 Jun 2005, Pablo Baena wrote:

> FOR rec IN SELECT test.id <http://test.id>, test.blow, test1.bla2
> FROM test
> LEFT JOIN test1 ON test.id <http://test.id> = 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!

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Problem on function returning setof custom type
Next
From: Tom Lane
Date:
Subject: Re: table and column information from cursor?