Nicolas Beuzeboc <[EMAIL PROTECTED]> writes:
> I which distinct on was more flexible, it's not happy when the order by
> set is different than the distinct on set.
> I would like to be able to write select distinct on (b,n) b,n,stamp from
> table where ... order by stamp;
Well, no, because it's
I which distinct on ...
I wish distinct on ...
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
Craig Ringer wrote:
b| n | stamp
A| 1 | 2008-09-20 06:07:47.981445 [1]
A| 1 | 2008-09-20 06:08:13.294306 [1]
A| 1 | 2008-09-20 06:12:02.046596 [1]
A| 2 | 2008-09-20 06:12:26.267786 [2]
A| 2 | 2008-09-20 06:12:47.75042
2008/9/23, Craig Ringer <[EMAIL PROTECTED]>:
> Mike Toews wrote:
>> Hi all,
>>
>> I have some records that have some multiple lines within a single text
>> field. (On top of that, I think I have mixed DOS/UNIX line endings too).
>> I'm looking for two functions which can operate on a single field:
On Mon, Sep 22, 2008 at 09:39:08AM -0700, Mark Roberts wrote:
>
> Taking your second email into account, I came up with:
>
> select distinct pt.type_fr
> from person_to_event pte
> inner join person_type using (id_person_type)
> where id_person_type in (
> select id_person_type
> from
