Lists: | pgsql-general |
---|
From: | Brandon Ibach <bibach(at)infomansol(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | CREATE OPERATOR error |
Date: | 1999-11-16 18:35:36 |
Message-ID: | 19991116123536.B16386@unix.netstream.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Can anybody explain what might be happening here?
abc=> create operator =* ( leftarg = varchar, rightarg = varchar,
abc-> procedure = vciceq, commutator = =* );
ERROR: parser: parse error at or near "varchar"
The function "vciceq" already exists, and works. I've tried a
number of variations on the above with different spacing, with no
success. Is there some syntax peculiarity I'm missing? This is on
PostgreSQL 6.5.2 on a Linux x86 system (RedHat 5.1, kernel 2.0.34).
TIA...
-Brandon :)
From: | ^chewie <chewie(at)wookimus(dot)net> |
---|---|
To: | Brandon Ibach <bibach(at)infomansol(dot)com> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] CREATE OPERATOR error |
Date: | 1999-11-16 21:32:49 |
Message-ID: | Pine.LNX.4.10.9911161532150.16841-100000@guinness.urw.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Tue, 16 Nov 1999, Brandon Ibach wrote:
BI> Can anybody explain what might be happening here?
BI>
BI> abc=> create operator =* ( leftarg = varchar, rightarg = varchar,
BI> abc-> procedure = vciceq, commutator = =* );
BI> ERROR: parser: parse error at or near "varchar"
BI>
BI> The function "vciceq" already exists, and works. I've tried a
BI> number of variations on the above with different spacing, with no
BI> success. Is there some syntax peculiarity I'm missing? This is
BI> on PostgreSQL 6.5.2 on a Linux x86 system (RedHat 5.1, kernel
BI> 2.0.34).
Isn't the operator '=*' a reserved operator for a right outer join?
Chad
From: | Brandon Ibach <bibach(at)infomansol(dot)com> |
---|---|
To: | ^chewie <chewie(at)wookimus(dot)net> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] CREATE OPERATOR error |
Date: | 1999-11-16 21:57:24 |
Message-ID: | 19991116155724.C16386@unix.netstream.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
Quoting ^chewie <chewie(at)wookimus(dot)net>:
> On Tue, 16 Nov 1999, Brandon Ibach wrote:
>
> BI> Can anybody explain what might be happening here?
> BI>
> BI> abc=> create operator =* ( leftarg = varchar, rightarg = varchar,
> BI> abc-> procedure = vciceq, commutator = =* );
> BI> ERROR: parser: parse error at or near "varchar"
> BI>
> BI> The function "vciceq" already exists, and works. I've tried a
> BI> number of variations on the above with different spacing, with no
> BI> success. Is there some syntax peculiarity I'm missing? This is
> BI> on PostgreSQL 6.5.2 on a Linux x86 system (RedHat 5.1, kernel
> BI> 2.0.34).
>
> Isn't the operator '=*' a reserved operator for a right outer join?
>
That may be, but I just tried it with an operator name of =: and
got the same result, so that doesn't appear to be the problem here. :(
-Brandon :)