Re: question on function definitions/casts

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Cindy <ctmoore(at)uci(dot)edu>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: question on function definitions/casts
Date: 2002-02-20 22:01:08
Message-ID: 20020220135921.X5356-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Darley 2002-02-20 22:19:13 Re: Ordering 'A', 'B', ..., 'Z', 'AA', 'AB', ...
Previous Message Bryan White 2002-02-20 21:54:09 Re: Ordering 'A', 'B', ..., 'Z', 'AA', 'AB', ...