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? (Josh Berkus)
Список
Дерево обсуждения
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 по дате отправления