Re: Does Postgresql have a similar pseudo-column "ROWNUM" as

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: Alain <alainm(at)pobox(dot)com>
Cc: Sql-Postgre <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
Date: 2005-05-17 20:11:38
Message-ID: 20050517201138.GD12405@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php pgsql-sql

On Tue, May 17, 2005 at 03:43:32PM -0300, Alain wrote:
>
> I tried using both the name and the primary key (with a combined index),
> to get faster to the record I want, but I was not sucessfull in building
> a where clause.
>
> I would appreciate any help, in fact this is my primary reason for
> joining this list ;-)

Well, then, table schemas, data distribution, EXPLAIN and EXPLAIN
ANALYSE output, and some statement of what you're trying to get out
is likely what we need to see.

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Ragnar Hafstað 2005-05-17 22:03:02 Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
Previous Message Mariusz Pękala 2005-05-17 19:17:37 Re: ERROR: unterminated quoted string... help

Browse pgsql-sql by date

  From Date Subject
Next Message Ragnar Hafstað 2005-05-17 22:03:02 Re: Does Postgresql have a similar pseudo-column "ROWNUM" as
Previous Message Mariusz Pękala 2005-05-17 19:17:37 Re: ERROR: unterminated quoted string... help