#@dbgenerated, multiple field slug?

4 messages · Page 1 of 1 (latest)

fervent sluice
#

something like this?:

@default( regexp_replace( lower( concat( field1 || ' ' || field2 ) ) ), '[^a-z0-9]', '-', 'gi' )
#

That expression works just like I want to when in a SELECT. I'm unsure how to migrate it to @default() though. Is it possible, to begin with? If not, is there some other way to set a default value like that?

#

Perhaps it's the wrong way to go about it? It's really a one-time run, I'd like to add the slug column and avoid that the existing rows in the table are left empty(which I guess doesn't work either since the slug column is supposed to be unique)

#

When new rows are inserted subsequently slug should have a value so the default value isn't needed anymore.