Re: Problem on function returning setof custom type

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

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Milorad Poluga 2005-06-22 16:36:14 How to compare the schemas ?
Previous Message SCassidy 2005-06-22 15:59:55 setting up PostgreSQL on Linux RHL9 to allow ODBC connections from Windows