Richard,
Please correct me if I am wrong.
You want to do something like:
select $1 from captives where firstname ~ '^(R[^ \t,]*d)$';
And get as result:
lastname
Richard
Richard
Richard
Ricard
Richard
Rolland
Richard
In this case, the above query is same as:
select firstname from captives whe
I am just getting started with pgsql and have read available docs I can
find.
I know I can match a row in a where clause using a regular expression.
How can I use what was regexp matched (e.g. perl $1,$2, etc...) as a column
assignment ?
I'm looking for something like this?
select ...
...
$1 of
