ERROR: volatile EquivalenceClass has no sortref

From: Ranjeet Dhumal <jeetu(dot)dhumal(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: volatile EquivalenceClass has no sortref
Date: 2012-11-21 11:23:25
Message-ID: CAFNnw=2wCORsLhks1kSagNu8Fw5tOcruegdGggbyEq3RpM+U5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi All ,

When am trying to query a table temp_table1(sms_type varchar(20),sms_info
varchar(100),sms_id integer)
Query :: select sms_type,count(*) from temp_table1 group by 1 order by 2
desc;
Then i got following errors , i dont know whats wrong in this .
*ERROR: volatile EquivalenceClass has no sortref*

This is my first post to forum , Please suggest me if i miss something .

--
--Regards
Ranjeet R. Dhumal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Kroon 2012-11-21 11:42:52 declare variable in udf
Previous Message Chris Travers 2012-11-21 10:21:37 Re: PostgreSQL training recommendations?

Browse pgsql-hackers by date

  From Date Subject
Next Message Ranjeet Dhumal 2012-11-21 12:37:19 Fwd: ERROR: volatile EquivalenceClass has no sortref
Previous Message Andres Freund 2012-11-21 11:08:00 Re: [PATCH] binary heap implementation