X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C2E519DC8AF for ; Thu, 22 Dec 2005 01:35:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 11375-08 for ; Thu, 22 Dec 2005 01:34:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from venus.amiindia.co.in (unknown [203.199.198.234]) by postgresql.org (Postfix) with ESMTP id 50F639DC81D for ; Thu, 22 Dec 2005 01:34:45 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by venus.amiindia.co.in (8.12.11/8.12.11) with SMTP id jBM5UJPo013457 for ; Thu, 22 Dec 2005 11:00:20 +0530 Received: from amiindiahjwbgh (unknown [10.0.0.205])by venus.amiindia.co.in (Postfix) with ESMTP id 02069332935; Thu, 22 Dec 2005 10:53:26 +0530 (IST) Message-ID: <001001c606b9$80b50060$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Cc: "sandhya" Subject: How to get OID return value(pls help me) Date: Thu, 22 Dec 2005 11:05:22 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000D_01C606E7.9A3C6860" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-imss-version: 2.5 X-imss-result: Passed X-imss-scores: Clean:85.94160 C:18 M:1 S:5 R:5 X-imss-settings: Baseline:5 C:3 M:3 S:4 R:3 (0.2500 0.7500) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.002 required=5 tests=[AWL=-0.000, HTML_MESSAGE=0.001, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.002 X-Spam-Level: X-Archive-Number: 200512/264 X-Sequence-Number: 19984 This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C606E7.9A3C6860 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi...... My table consists of oid and varchar datatypes. I want to get the oid type from the table and i need to pass it to a = function which accepts only the oid data type. But my problem is the return value of the datatype i am getting from the = query result is char*. Is there any function in postgresql which gives the return value of the = executed query as OID type. Please explain me what to do inorder to get the Oid type=20 When i used PQoidValue(res).It is giving 0. Also in document they mention something related to INSERT query only. But i want it for select query. Thank you, Regards, Sandhya ------=_NextPart_000_000D_01C606E7.9A3C6860 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi......
 
 
My table consists of oid and=20 varchar datatypes.
I want to get the oid type from = the=20 table and i need to pass it to a function = which=20 accepts only the oid data type.
But my problem is the=20 return value of the datatype i am getting from = the=20 query result is char*.
Is there any function in=20 postgresql which gives the return value of the = executed query as OID type.
 
Please explain me what to do inorder to = get the Oid=20 type
When i used PQoidValue(res).It is = giving=20 0.
Also in document they mention something = related to=20 INSERT query only.
But i want it for select = query.
Thank you,
Regards,
Sandhya
------=_NextPart_000_000D_01C606E7.9A3C6860--