Re: libpq and prepared statements progress for 8.0 - Mailing list pgsql-hackers

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