On Fri, Sep 10, 2010 at 11:07 PM, <tony@xxxxxxxxxxxxxxxxxxx> wrote: > Using PostgreSQL I can't open a table and do seeks against an index. I > could do a select against the database and see if 0 records are returned, > but that seems to take more time than doing a seek on an index. Is there a > more SQL friendly way of handling this task? I come a foxpro background too, and I can tell you for sure postgres indexes should give you similar performance to what you're used to. Do you have an index on the table? merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general