Re: Directly embedding a psql SET variable inside another string?

On 1/13/23 09:08, Adam Scott wrote:
> Do you mean like this?
> 
> postgres=# \set v_embed %:v_ssn%
> postgres=# \echo :v_embed
> %345%
> postgres=#  SELECT * FROM employee WHERE ssn LIKE :'v_embed';
>      ssn    |   name
> -----------+----------
>   123456789 | John Doe
> (1 row)
> 
> 

Actually that replicates what Ron got to work. What Ron is looking for 
is to skip the intermediate step and do:

\set v_ssn 345
SELECT * FROM employee WHERE ssn LIKE :'%v_ssn%';

-- 
Adrian Klaver
adrian.klaver@aklaver.com