Postgres Pro
Downloads
Home   >   mailing lists

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

From PFC
Subject Re: interesting SQL puzzle - concatenating column with itself.
Date
Msg-id op.sqxlh6zath1vuj@localhost
Whole thread Raw
In response to Re: interesting SQL puzzle - concatenating column with itself.  ("Dmitri Bichko" <dbichko@aveopharma.com>)
List pgsql-sql
Tree view 
> 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 ...

pgsql-sql by date:

Previous
From: Alain
Date:
Subject: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
Next
From: Jay Parker
Date:
Subject: triggering an external action