Re: [HACKERS] Associative Operators? (Was: Re: [NOVICE] Out of frying pan, into fire) - Mailing list pgsql-hackers

This is fixed in 6.5 beta.


> Seth McQuale pointed out that the follwing does not work:
>   SELECT LASTNAME || ',' || FIRSTNAME [AS] NAME FROM FRIENDS;
> 
> The solution, was:
>   SELECT ( LASTNAME || ',' ) || FIRSTNAME AS NAME FROM FRIENDS;
> 
> I looked at pg_operator and didn't see any flag to mark
> an operator as 'associative'.   Perhaps if we added a flag
> like this, the re-write system could be modified to handle
> cases like this.
> 
> Thoughts?
> 
> Clark Evans
> 
> 


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026