| 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: | Whole Thread | Raw Message | 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 |