| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Alejandro Cicero <acicero(at)afip(dot)gov(dot)ar> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Consulta |
| Date: | 2001-04-26 15:36:26 |
| Message-ID: | Pine.LNX.4.30.0104261733300.758-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-04-26 15:38:00 | Re: Why Size Of Data Backed Up Varies Significantly In SQL 6.5? |
| Previous Message | Peter Eisentraut | 2001-04-26 15:32:45 | Re: help with serial type |