On Wed, Nov 23, 2005 at 02:54:27PM +0300, Eugene E. wrote: > template1=> \set a select > template1=> \set b 1 > template1=> :a :b; > > column > ------ > 1 > > hope this is only psql's feathure not the server's one;
What about this do you find surprising? Have you read the psql documentation regarding \set, variables, and interpolation? http://www.postgresql.org/docs/8.1/interactive/app-psql.html#APP-PSQL-VARIABLES test=> \set a select test=> \set b 1 test=> \set ECHO queries test=> :a :b; select 1; ?column? ---------- 1 (1 row) -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
