Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause

2001-12-19 Thread Bill Studenmund
On Mon, 17 Dec 2001, Tom Lane wrote: > Justin <[EMAIL PROTECTED]> writes: > > On Saturday 15 December 2001 03:06, Tom Lane wrote: > >> It's too late to fix this in the standard catalogs for 7.2, but I'll > >> make a note for 7.3. > > > Suitable for 7.2.1? > > Nyet. We don't do initdbs for dot-re

Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause

2001-12-16 Thread Bruce Momjian
> On Saturday 15 December 2001 03:06, Tom Lane wrote: > > [EMAIL PROTECTED] writes: > > > > > 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 sa

Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause (MINOR A NNOYANCE)

2001-12-16 Thread Tom Lane
Justin <[EMAIL PROTECTED]> writes: > On Saturday 15 December 2001 03:06, Tom Lane wrote: >> It's too late to fix this in the standard catalogs for 7.2, but I'll >> make a note for 7.3. > Suitable for 7.2.1? Nyet. We don't do initdbs for dot-releases. Sometime in the future, it might be nice to

Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause (MINOR A NNOYANCE)

2001-12-16 Thread Justin
On Saturday 15 December 2001 03:06, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > 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-equal

Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause

2001-12-15 Thread Bruce Momjian
> 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| h

Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause (MINOR A NNOYANCE)

2001-12-15 Thread Tom Lane
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 ---

Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause

2001-12-15 Thread Bruce Momjian
> [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

Re: [BUGS] Unable to compare _bpchar for similarity in WHERE-clause (MINOR A NNOYANCE)

2001-12-14 Thread Tom Lane
[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 usin

[BUGS] Unable to compare _bpchar for similarity in WHERE-clause (MINOR ANNOYANCE)

2001-12-14 Thread Nicolai
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 sta