DISTINCT ON con columna hstore

From: Tonny <tonny(dot)lists(at)gmail(dot)com>
To: ecpug(at)postgresql(dot)org
Subject: DISTINCT ON con columna hstore
Date: 2013-01-21 21:42:57
Message-ID: 50FDB661.2090104@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: ecpug

SELECT DISTINCT ON (tags->'name') tags->'name' AS nombre, columna2,
columna3 FROM tabla1;

Hola a todos.
Como puedo hacer un distinct ON, solo de un atributo de un campo hstore

gracias

Responses

Browse ecpug by date

  From Date Subject
Next Message Jaime Casanova 2013-01-21 22:18:13 Re: DISTINCT ON con columna hstore
Previous Message Capacitación PostgreSQL 2013-01-21 21:39:43 Curso de Administración sobre PostgreSQL