AW: [HACKERS] Getting OID in psql of recent insert

From: Zeugswetter Andreas SEV <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Peter Eisentraut'" <peter_e(at)gmx(dot)net>
Cc: "'PostgreSQL-development'" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: AW: [HACKERS] Getting OID in psql of recent insert
Date: 1999-11-22 17:06:46
Message-ID: 219F68D65015D011A8E000006F8590C603FDC181@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1999-11-22 17:47:26 Re: [HACKERS] Re: postgres RPM build on Suse linux 6.2
Previous Message Lamar Owen 1999-11-22 16:40:17 Re: postgres RPM build on Suse linux 6.2