| From: | Oliver Jowett <oliver(at)opencloud(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | David Wheeler <david(at)kineticode(dot)com>, pgsql-hackers(at)postgresql(dot)org, Rudy Lippan <rlippan(at)remotelinux(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, Greg Sabino Mullane <greg(at)turnstep(dot)com> |
| Subject: | Re: libpq and prepared statements progress for 8.0 |
| Date: | 2004-09-18 01:23:55 |
| Message-ID: | 414B8E2B.8010109@opencloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Oliver Jowett wrote:
> template1=> prepare s1(int) as select $1;
> PREPARE
> template1=> execute s1('12');
> ?column?
> ----------
> 12
> (1 row)
>
> (now replace "int" with "unknown"..)
Ok, bad example since the backend probably can't infer a type for the
PREPARE in this case. A better example:
> template1=> prepare s1(int) as select typname from pg_type where oid = $1;
> PREPARE
> template1=> execute s1('16');
> typname
> ---------
> bool
> (1 row)
-O
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2004-09-18 10:06:05 | Re: signal 11 on AIX: 7.4.2 |
| Previous Message | Oliver Jowett | 2004-09-18 01:14:50 | Re: libpq and prepared statements progress for 8.0 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James William Pye | 2004-09-18 07:24:33 | Re: log rotatoin doc updates |
| Previous Message | Oliver Jowett | 2004-09-18 01:14:50 | Re: libpq and prepared statements progress for 8.0 |