Re: interesting SQL puzzle - concatenating column with itself.

From: PFC <lists(at)boutiquenumerique(dot)com>
To: "Dmitri Bichko" <dbichko(at)aveopharma(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: interesting SQL puzzle - concatenating column with itself.
Date: 2005-05-17 17:57:32
Message-ID: op.sqxlh6zath1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Trick to fool postgres into thinking it can't rewrite out your subquery
and eliminate it ...

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jay Parker 2005-05-17 18:01:18 triggering an external action
Previous Message Alain 2005-05-17 17:48:49 Re: Does Postgresql have a similar pseudo-column "ROWNUM" as