One time only trigger/function on every row... - Mailing list pgsql-general

From wyatt@draggoo.com
Subject One time only trigger/function on every row...
Date
Msg-id 20011117205542.14874.cpmta@c001.snv.cp.net
Whole thread Raw
Responses Re: One time only trigger/function on every row...  ("Andrew G. Hammond" <drew@xyzzy.dhs.org>)
List pgsql-general
I didn't even think of this as I was adding books into my database, but I didn't rearrange the titles ('Shining, The'
asopposed to 'The Shining') like I should have. 

I'm writing a function to use as a trigger to check and, if need be, rearrange the titles as they are added to the
database,but is there an easy way to loop through all of the records currently in the database and run that function on
them?

Thanks,
Wyatt



pgsql-general by date:

Previous
From: Grant Table
Date:
Subject: Re: Triggers, functions and column names: a poser
Next
From: David Wheeler
Date:
Subject: DBD::Pg BYTEA Character Escaping