Rich Shepard <rshepard@xxxxxxxxxxxxxxx> writes: > Long ago I wrote a query which was greatly improved (i.e., it actually > worked as intended) by help here): > SELECT ... > WHERE p.lname = &p.lname AND p.fname = &p.fname; > I did not save the reason why the ampersand is used in the WHERE row selection > phrase and want now to learn why it's there. Probably needed to concatenate > separate names? AFAICS this is invoking a prefix operator named "&". There is no such operator built into Postgres. Maybe psql's "\do+ &" would jog your memory about where yours came from. regards, tom lane
