question on function definitions/casts
ANyway, I have another question for you guys.
create function get_citation (int2, int2, int4)
returns SETOF varchar AS
'select citation from citations where aid=$1 and wid=$2 and byteloc=$3'
LANGUAGE 'SQL'
At one point I retrieved this function from my psql db (I've taken over
from someone else) and I'm now in a position where I need to enter it again.
I got it using pg_dump -s (on the kind suggestion of Tom when I asked back
then).
However, when I enter it now, it just doesn't seem to like it.
I get:
Text=# create function get_citation (int2, int2, int4)
Text-# returns SETOF varchar AS
Text-# 'select citation from citations where aid=$1 and wid=$2 and byteloc=$3'
Text-# LANGUAGE 'SQL';
ERROR: Unable to identify an operator '=$' for types 'int2' and 'int4'
You will have to retype this query using an explicit cast
Text=#
I'm guessing this is a difference from an upgrade to psql?
I'm using:
[1:08pm] stephanus ~> psql -V
psql (PostgreSQL) 7.1.3
would this be something like:
cast(aid as int2)=$1
or
(int2 aid)=$1
I've read through the stuff in
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/typeconv-oper.html
but I'm still confused.
Thanks,
--Cindy
On Wed, 20 Feb 2002, Cindy wrote:
I get:
Text=# create function get_citation (int2, int2, int4)
Text-# returns SETOF varchar AS
Text-# 'select citation from citations where aid=$1 and wid=$2 and byteloc=$3'
Text-# LANGUAGE 'SQL';
ERROR: Unable to identify an operator '=$' for types 'int2' and 'int4'
You will have to retype this query using an explicit cast
Text=#
Hmm, try putting a space between the = and the $<n>
Stephan Szabo writes:
On Wed, 20 Feb 2002, Cindy wrote:
I get:
Text=# create function get_citation (int2, int2, int4)
Text-# returns SETOF varchar AS
Text-# 'select citation from citations where aid=$1 and wid=$2 and byteloc=$3'
Text-# LANGUAGE 'SQL';
ERROR: Unable to identify an operator '=$' for types 'int2' and 'int4'
You will have to retype this query using an explicit cast
Text=#Hmm, try putting a space between the = and the $<n>
Yep. The irony of this, of course, is that the first problem I solved
with this saved definition is that SETOF was originally SET OF.
So...subtract spaces, add spaces...*sigh*
Thanks!
--
Cindy
ctmoore@uci.edu
Import Notes
Reply to msg id not found: YourmessageofWed20Feb2002140108-0800.20020220135921.X5356-100000@megazone23.bigpanda.com | Resolved by subject fallback