On Apr 6, 2011, at 4:21 PM, tejas tank wrote: > ERROR: more than one row returned by a subquery used as an expression > ********** Error ********** > ERROR: more than one row returned by a subquery used as an expression > SQL state: 21000 Error Message is showing that you are using subquery with single comparison operator (like "=" ) in condition clause. Please share the query which is giving this error message Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.kumar@xxxxxxxxxxxxxxxx Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general