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
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 |
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 |