Postgres Pro
Downloads
Home   >   mailing lists

Re: interesting SQL puzzle - concatenating column with itself. - Mailing list pgsql-sql

From Dmitri Bichko
Subject Re: interesting SQL puzzle - concatenating column with itself.
Date
Msg-id 7A4ADADFC8AFF0478D47F63BEDD57CE3A27953@gpmail.gphq.genpathpharma.com
Whole thread Raw
In response to interesting SQL puzzle - concatenating column with itself.  (Nick Fankhauser <nickf@ontko.com>)
Responses Re: interesting SQL puzzle - concatenating column with itself.
List pgsql-sql
Tree view 
> SELECT your_concat( memo_text ) FROM
> (SELECT memo_id, sequence, memo_text FROM table ORDER BY memo_id,
sequence
> OFFSET 0) AS foo
> GROUP BY memo_id

I'm just curious - what's the 'OFFSET 0' for?

Dmitri

pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: getting duplicate number is there a
Next
From:
Date:
Subject: Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?