I've found a reason! It's some namespace problem - there are other
tho name_ops operator classes exist. My becomes third. All are the
default for (their) type. And somewhere there is the issue. Renaming
my operator class into, say, name_t_ops resolves the problem.
Thanks for the info.
--
Aaron Chu wrote:
>Hi,
>
>I have a table which has a column of surnames (string) and I would
like >to know how can I retrieve (SELECT) all the repeated surnames,
i.e. >more than one person who has the same surname.
>Thanks.
What exactly you want to do? To eliminate duplicates? Use then:
select s
Denis Zaitsev <[EMAIL PROTECTED]> writes:
> ERROR: data type name_t has no default operator class for access method "btree"
Hm, that looks like it should work. You sure you marked the opclass
default? (Check its row in pg_opclass to see.)
Another possibility is that the opclass is in a schema
Jack Kiss <[EMAIL PROTECTED]> writes:
> 1)Do you have a function which is similar to Oracle\'s DECODE.
Yes
> 2) Can you extract day of week (Monday,etc) from yours date functions.
Yes
Check out the "Date/Time Function and Operators" and the "Conditional
Expressions" sections of this:
http://
