pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedwhat is going on in the PostgreSQL
2+ messages / 2 participants
[nested] [flat]
* what is going on in the PostgreSQL
@ 2005-11-23 11:54 Eugene E. <sad@bankir.ru>
2005-11-23 18:09 ` Re: what is going on in the PostgreSQL Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 2+ messages in thread
From: Eugene E. @ 2005-11-23 11:54 UTC (permalink / raw)
To: ; +Cc: pgsql-sql
Hello all !
look
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;
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: what is going on in the PostgreSQL
2005-11-23 11:54 what is going on in the PostgreSQL Eugene E. <sad@bankir.ru>
@ 2005-11-23 18:09 ` Michael Fuhr <mike@fuhr.org>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Fuhr @ 2005-11-23 18:09 UTC (permalink / raw)
To: Eugene E. <sad@bankir.ru>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-11-23 18:09 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-23 11:54 what is going on in the PostgreSQL Eugene E. <sad@bankir.ru>
2005-11-23 18:09 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox