Re: what is going on in the PostgreSQL - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: what is going on in the PostgreSQL
Date
Msg-id 20051123180957.GA3907@winnie.fuhr.org
Whole thread Raw
In response to what is going on in the PostgreSQL  ("Eugene E." <sad@bankir.ru>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: unplanned sub-select error?
Next
From: "Ken Winter"
Date:
Subject: