Re: Function created yet not found

Call off the dogs. =)

I dug deeper, and found that it wasn't the function that was throwing
the error, but the table it was selecting from. Examining the table
further....

test=# \d entity
Table "entity"
Attribute | Type | Modifier
-----------+-------------------+----------
entity_id | integer |
name | character varying |
type | character varying |
active | boolean |
lft | integer |
rgt | integer |
Indices: entity_findsite_idx,
entity_lft_rgt_idx,
entity_rgt_idx

entity_findsite_idx looked odd to me, not my usual naming scheme.
Co-worker had tested making an index using a function: 'create index
entity_findsite_idx on entity (findsite(entity_id))'. I had since
dropped and reloaded that function, rendering the table useless.

My apologies for prematurely posting. I've never used function-based
indices....would a select findsite(entity_id) from entity actually have
used that index? That could be handy.

Thanks,
Fran