Re: DataType OID for PQexecParams-call in libpq - Mailing list pgsql-interfaces

From Gergely Czuczy
Subject Re: DataType OID for PQexecParams-call in libpq
Date
Msg-id Pine.LNX.4.44.0403161435200.22549-100000@localhost
Whole thread Raw
In response to DataType OID for PQexecParams-call in libpq  ("Jan Klostermann" <klostermann@rhf.de>)
Responses Re: DataType OID for PQexecParams-call in libpq  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-interfaces
hello

please take a look at the documentation at
http://www.postgresql.org/docs/7.4/static/libpq-exec.html
at the point "PQftype", where it's said:
" The OIDs of the built-in data types are defined in the file
src/include/catalog/pg_type.h in the source tree."

Bye,

Gergely Czuczy
mailto: phoemix@harmless.hu
PGP: http://phoemix.harmless.hu/phoemix.pgp

The point is, that geeks are not necessarily the outcasts
society often believes they are. The fact is that society
isn't cool enough to be included in our activities.

On Tue, 16 Mar 2004, Jan Klostermann wrote:

> Hello all!
>
> I would be very thankful, if you could help me out!
>
> To call the PQexecParams() function I need to provide a field with the
> data types of the parameters as type OID. OID is a number, but which
> numbers correspond to with datatype ?
> Where are they documented? Or how can I find out about this data type
> codes?
>
> I scanned trough almost the whole documentation but could not find
> anything. The examples just skip the problem by using simple strings and
> auto-detection.
>
> Any help would be very appreciated! Thanks in advance.
>
> Jan Klostermann
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>



pgsql-interfaces by date:

Previous
From: "Jan Klostermann"
Date:
Subject: DataType OID for PQexecParams-call in libpq
Next
From: Tom Lane
Date:
Subject: Re: DataType OID for PQexecParams-call in libpq