Find one record

Поиск
Список
Период
Сортировка
Искать
От
Joseph Bove
Тема
Find one record
Дата
Msg-id
5.1.0.14.2.20030918135557.03ab89d8@mail.vetstar.com
Ответ на
Список
Дерево обсуждения
Re: rewrite in to exists? LN Cisneros <lnsea@earthlink.net>
Re: rewrite in to exists? Josh Berkus <josh@agliodbs.com>
Find one record Joseph Bove <jbove@vetstar.com>
Re: Find one record Josh Berkus <josh@agliodbs.com>
Dear list,

I hope this to be a simple question. I have need to simply read the first 
row in a given table. Right now,  I have some legacy code that selects all 
rows in a table just to see if the first row has a certain value.

The code is seeking to see if an update has been run or not. A hypothetical 
scenario would be: has an update been run to populate data into a new 
column in a table. Neither the data nor any of the rows are consistently 
known. So the test selects all rows, tests the first row and then ends if 
the column has a value.

Does anyone have a better way to do this?

Regards

В списке pgsql-performance по дате отправления
От: Josh Berkus
Дата:
Сообщение: Re: rewrite in to exists?
От: Josh Berkus
Дата:
Сообщение: Re: How to force an Index ?
FAQ