Anchoring random numbers

Is there anyway to anchor a random number? I am using a random(). The script runs daily and adds new rows. I want the random number to stay consistent on existing rows and add a new random number on new rows. I am using Amazon Redshift DB, SQL. Thank you Set seed42; Select ID, random() from existing table where --parameters that populate the row--