Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause
> [EMAIL PROTECTED] writes:
> > When I try to write an UPDATE where I include a WHERE-clause like:
> > [WHERE something='{"a","b","c"}], where something is a character[], i get
> > the errormessage:[Unable to identify an operator = for types '_bpchar and
> > 'unknown' You will have to retype this query using an explicit cast]
> > The above statement works for text[].
>
> Hmm. Looks like there is a pg_operator entry for text[] = text[],
> but none for bpchar[] = bpchar[]. This is an oversight, nothing more.
> Feel free to add such an entry --- it can point to the same array-equals
> function as the one for text[].
>
> It's too late to fix this in the standard catalogs for 7.2, but I'll
> make a note for 7.3.
Added to TODO:
* Add bpchar array comparison
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup.| Drexel Hill, Pennsylvania 19026
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause (MINOR A NNOYANCE)
Bruce Momjian <[EMAIL PROTECTED]> writes: > Added to TODO: > * Add bpchar array comparison Varchar and very probably other ones are missing too. Make it * Ensure we have array-eq operators for every built-in array type regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause
> Bruce Momjian <[EMAIL PROTECTED]> writes: > > Added to TODO: > > * Add bpchar array comparison > > Varchar and very probably other ones are missing too. Make it > * Ensure we have array-eq operators for every built-in array type Done. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
