Re: libpq and prepared statements progress for 8.0

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: Whole Thread | Raw Message | 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

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-patches by date

  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