From: David BOURIAUD <david.bouriaud@ac-rouen.fr>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: About primary keys.
Date: Tue, 19 Jun 2001 16:38:44 +0200
Message-ID: <3B2F63F4.ED1215AB@ac-rouen.fr> (raw)
References: <3B2F4128.D9D38897@ac-rouen.fr>
<20010619074918.A30985@cc.usu.edu>
Roberto Mello wrote:
>
> On Tue, Jun 19, 2001 at 02:10:16PM +0200, David BOURIAUD wrote:
> > Hi the list !
> > Is there a way to get in system tables all the primary keys of a table ?
>
> There's a recipe that is related to that in my Postgres CookBook that
> you could adapt to your needs:
>
> http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=36
>
> -Roberto
Hi !
Thankx ! Indeed, it could (and will be) adapted, but it uses many unions
for one unique querry. It's a shame that there is no operator to check
if a value belongs to an int2vector. Why not having an operator such as
this one :
select ...
from ....
where attribute in int2vector ?
This could be included in the wish list, couldn't it ?
Anyway, thanks, for I can go further in my programm.
--
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have
for windows or gates ?
----------------------------------------------------------
ICQ#102562021
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david.bouriaud@ac-rouen.fr
Subject: Re: About primary keys.
In-Reply-To: <3B2F63F4.ED1215AB@ac-rouen.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox