Re: Is there a way to create a functional index that tables tableoid column as an arg?

Ryan Murphy writes: > Hi David! Thanks for the reply. >> tableoid might be an exception to >> this, but it does not really seem like a useful column to index, >> giving it would be indexing the same value for each record in the >> table. > Unless you're using inheritance

Re: Is there a way to create a functional index that tables tableoid column as an arg?

Hi David! Thanks for the reply. > tableoid might be an exception to > this, but it does not really seem like a useful column to index, > giving it would be indexing the same value for each record in the > table. Unless you're using inheritance - then tableoid may vary. That's the case I'm

Re: Is there a way to create a functional index that tables tableoid column as an arg?

On 11 March 2018 at 07:53, Ryan Murphy wrote: > I am using table inheritance and have e.g. the following tables: > > create table animal ( ... ); > create table dog ( ... ) inherits (animal); > create table cat ( ... ) inherits (animal); > create table

Is there a way to create a functional index that tables tableoid column as an arg?

Hello Postgressers, I am using table inheritance and have e.g. the following tables: create table animal ( ... ); create table dog ( ... ) inherits (animal); create table cat ( ... ) inherits (animal); create table person ( ... ) inherits (animal); create table musician ( ...