Philip Brooks <philswatch(at)yahoo(dot)com> writes:
> In SQLite, I did it with this:
> UPDATE bf
> SET title = (
> SELECT title
> FROM bf AS prev
> WHERE title IS NOT NULL AND prev.rowid < bf.rowid
> ORDER BY prev.rowid DESC
> LIMIT 1
> )
> WHERE title IS NULL
> The update is not porting to Postgresql.
Really? Seems to work for me.
regards, tom lane