Re: interesting SQL puzzle - concatenating column with itself.

From: "Dmitri Bichko" <dbichko(at)aveopharma(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: interesting SQL puzzle - concatenating column with itself.
Date: 2005-05-10 21:53:59
Message-ID: 7A4ADADFC8AFF0478D47F63BEDD57CE3A27953@gpmail.gphq.genpathpharma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dennis.Jiang 2005-05-12 19:07:00 Does Postgresql have a similar pseudo-column "ROWNUM" as Oracle?
Previous Message PFC 2005-05-10 20:45:38 Re: interesting SQL puzzle - concatenating column with itself.