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