Consulta

Alejandro Cicero writes:

En ORACLE, puedo pasar parametros a un query de la siguiente manera:

select campo1, campo2

from tabla1

where campo3=&variable

En Postgres como se hace?

If you are using Embedded SQL (epgc) then it's probably :variable. If
you're in PL/pgSQL then it's just the name of the variable without special
characters. Otherwise you need to prepare the query string in your client
application before sending it to the database server. PostgreSQL doesn't
have generic server-side variables.

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter