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

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>