Re: question on function definitions/casts

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(at)uci(dot)edu