pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: tlund79 <thomas.lund@eniro.no>
To: pgsql-sql@postgresql.org
Subject: Re: Issue with a variable in a function
Date: Wed, 9 Nov 2011 02:41:39 -0800 (PST)
Message-ID: <1320835299242-4977361.post@n5.nabble.com> (raw)
In-Reply-To: <B4EB9C9043754B458497ED2C0CD37CF240590F8E29@fixoosr61.findexa.net>
References: <1320758213629-4974235.post@n5.nabble.com>
	<006801cc9e3b$bb177ec0$31467c40$@yahoo.com>
	<B4EB9C9043754B458497ED2C0CD37CF240590F8E29@fixoosr61.findexa.net>

I solved this one by trial and error. You were right I needed brackets to
indicate an array, but also needed to replace "in ($4)" with "= any ($4)"

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Issue-with-a-variable-in-a-function-tp4974235p4977361.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

view thread (4+ messages)

Message-ID: <1320835299242-4977361.post@n5.nabble.com>
Permalink:  ../1320835299242-4977361.post@n5.nabble.com/
Also on:    postgresql.org/message-id/1320835299242-4977361.post@n5.nabble.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: thomas.lund@eniro.no
  Subject: Re: Issue with a variable in a function
  In-Reply-To: <1320835299242-4977361.post@n5.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox