AW: [HACKERS] Getting OID in psql of recent insert - Mailing list pgsql-hackers

From Zeugswetter Andreas SEV
Subject AW: [HACKERS] Getting OID in psql of recent insert
Date
Msg-id 219F68D65015D011A8E000006F8590C603FDC181@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: [HACKERS] Getting OID in psql of recent insert  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: [HACKERS] Getting OID in psql of recent insert  (SAKAIDA Masaaki <sakaida@psn.co.jp>)
Re: AW: [HACKERS] Getting OID in psql of recent insert  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> testdb=> \set singlestep on
> testdb=> \set sql_interpol '#'
> testdb=> \set foo 'pg_class'
> testdb=> select * from #foo#;

This is great, but may I object to the syntax ?
The standard sql way to use host variables seems to be:
select * from :foo where id = :id

There will always be the problem with conflicting operators,
and this one syntax, already needed by ecpg, it is hard enough.

Andreas


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: postgres RPM build on Suse linux 6.2
Next
From: Bruce Momjian
Date:
Subject: Re: AW: [HACKERS] Getting OID in psql of recent insert