Re: oid in a where

Lists: pgsql-hackers
From: Alberto J(dot) Castiñeira P(dot) <ajcastineira(at)gmail(dot)com>
To: Postgre Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: oid in a where
Date: 2009-04-17 16:01:59
Message-ID: 2dfb67510904170901r4496a1cuc1e378421c621653@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi.
I'll like to know how to use the "oid" in a where clause expressing the
value in form of string or number.

many thanks.

--
atte: Alberto J. Castiñeira P.
AJCP


From: Alberto J(dot) Castiñeira P(dot) <ajcastineira(at)gmail(dot)com>
To: Postgre Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: oid in a where
Date: 2009-04-17 16:07:20
Message-ID: 2dfb67510904170907m5cbae627id998cfe1ec2eceb5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi.
I'll like to know how to use the "oid" in a where clause expressing the
value in form of string or number.

many thanks.

--
atte: Alberto J. Castiñeira P.
AJCP

--
atte: Alberto J. Castiñeira P.
AJCP


From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Alberto J(dot) Castiñeira P(dot) <ajcastineira(at)gmail(dot)com>
Cc: Postgre Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: oid in a where
Date: 2009-04-17 16:24:02
Message-ID: 603c8f070904170924m2383bd81oa71e4cf8df89c482@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

This question is not appropriate for pgsql-hackers. You might try
pgsql-general or pgsql-novice.

Anyhow, it's just:

SELECT * FROM pg_class WHERE oid = 1247;

...Robert

2009/4/17 Alberto J. Castiñeira P. <ajcastineira(at)gmail(dot)com>:
> Hi.
> I'll like to know how to use the "oid" in a where clause expressing the
> value in form of string or number.
> many thanks.
>
> --
> atte: Alberto J. Castiñeira P.
>                  AJCP
>