Re: question on function definitions/casts - Mailing list pgsql-general

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