Re: [GENERAL] Dangers of mislabelled immutable functions

2015-08-21 Thread Albe Laurenz
Jeff Janes wrote: > I want to index the textual representations of a table's rows. > > You can cast a row to text by using the name of the table where you would > usually use the name of a > column, like "table_name::text". But this is not immutable and so can't be > used in an expression > ind

[GENERAL] Dangers of mislabelled immutable functions

2015-08-20 Thread Jeff Janes
I want to index the textual representations of a table's rows. You can cast a row to text by using the name of the table where you would usually use the name of a column, like "table_name::text". But this is not immutable and so can't be used in an expression index. I can easily make a pl/perl f