selecting un-ordered rows

From: Dušan PEŠL <pesl(at)asprkyjov(dot)cz>
To: pgsql-novice(at)postgresql(dot)org
Subject: selecting un-ordered rows
Date: 2006-05-16 11:34:33
Message-ID: 4469B8C9.3010808@asprkyjov.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

have enyone idea, how to select all rows, preceeding 'mary'
(first two rows, but not LIMIT 2)

name date
albert 2006-05-17
john 2006-05-17
mary 2006-05-17
benjamin 2006-05-17
carl 2006-05-17
alice 2006-05-17

thanks for help

Dan

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Cédric BUSCHINI 2006-05-16 12:08:13 VACCUM VERBOSE ANALYZE
Previous Message Jose Apablaza 2006-05-16 08:45:05 Re: MySQL DB to PostgresSQL DB