Mark Dalphin <mdalphin@amgen.com> writes:
> And this is the error I get when I try to insert anything, regardless
> of whether the foreign key exists or not:

> ERROR:  There is no operator '=$' for types 'int4' and 'int4'

I see it too.  Looks like a bug ...

			regards, tom lane

Sat, 14 Aug 1999 11:10:22 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [SQL] Anyone recognise this error from PL/pgSQL? 
> > And this is the error I get when I try to insert anything, regardless
> > of whether the foreign key exists or not:
> > ERROR:  There is no operator '=$' for types 'int4' and 'int4'
> I see it too.  Looks like a bug ...

I seem to have lost this thread. But in case it hasn't been suggested,
try putting a space between the equals sign and the dollar sign...

                       - Thomas

-- 
Thomas Lockhart				lockhart@alumni.caltech.edu
South Pasadena, California

Sat, 14 Aug 1999 15:26:37 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: [HACKERS] Re: [SQL] Anyone recognise this error from PL/pgSQL?
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
>>>> And this is the error I get when I try to insert anything, regardless
>>>> of whether the foreign key exists or not:
>>>> ERROR:  There is no operator '=$' for types 'int4' and 'int4'
>> I see it too.  Looks like a bug ...

> I seem to have lost this thread.

Sorry, it was over in pgsql-sql (and probably should have been in BUGS).
I just wanted to draw attention to it in the hackers list.

> But in case it hasn't been suggested,
> try putting a space between the equals sign and the dollar sign...

There isn't any '$' anywhere in his function ... plpgsql is dropping the
ball somehow.

			regards, tom lane

Sat, 14 Aug 1999 11:30:24 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Re: [SQL] Anyone recognise this error from PL/pgSQL? 